Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Views and Sql select
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Views and Sql select
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01611221
Message ID:
01611221
Views:
56
Hi
In some of my forms I use Views to handle the Rows Maintenance, and when saving I update the Database from the Views
However, I notcie if I do Select * from MyView into Cursor MyCursor, I dont get any amendments to the view
(It seems to hold the original version of it)

If I loop down through the View, the data is there fine (showing any amendments)

Is there something I am missing that I am not getting the amended view into the Sql select statement
(I dont want to update the database yet but need to do some additional checking and Sql Select would be idel)

Tia
Gerard
Next
Reply
Map
View

Click here to load this message in the networking platform