General information
Category:
Coding, syntax & commands
Title:
Views and Sql select
Environment versions
Network:
Windows 2008 Server
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only