Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote View
Message
From
23/12/1997 12:55:11
Bob Lucas
The WordWare Agency
Alberta, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Remote View
Miscellaneous
Thread ID:
00067712
Message ID:
00067712
Views:
62
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
Map
View

Click here to load this message in the networking platform