Here is an interesting problem. I have a remote view that I use to update data. When a new record is added, it updates to the back end just fine (SQL Server). After a data save (some 17 views) I reload all the data. This works fine too. However, If I edit a second time and then save (even making no data changes) ONE of the views does not return the data that exists on SQL Server. This is very strange. I have paused execution after the Requery of the view so that I can check the last statement that executed on SQL Server. When the view returns data and when it does not (empty cursor) the executing statement on the back end is exactly the same! This makes no sense whatever! What I have been forced to do now is close the view cursor and reopen the view so that it will return data. Has anyone ever had this kind of experience. All the other remot views work fine.
Thanks
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