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
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