Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
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)
>
Probably buffering effects. Add:
WITH (Buffering=.t.)
to the FROM clause.
Tamar
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement