Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Requery() of parameterized view returns -1
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00509963
Message ID:
00510091
Views:
24
Have you checked update all , Send SQL update in update criteria and Share Connection in Advanced Option of remote view ?

>I have a form that contains a list box and a grid. As the user selects an item in the list box the grid is automatically updated with the items that match the selected item. The grid data is based on a parameterized remote view. This works fine except when a user makes changes to the data in the grid and saves the changes. If the user cancels the changes things continue to work correctly. To save I issue a TABLEUPDATE(.T.,.T.,'viewname'). To cancel I issue a TABLEREVERT(.T.,'viewname'). After the save, when the user select a different item in the list box, the REQUERY('viewname') returns a -1, the remote view data is not changed.
>
>The remote view is buffered with CURSORSETPROP("Buffering",5,"viewname").
>
>Does anyone have any suggestions as to how I can resolve this problem. Any help would be greatly appreciated.
>
>Thanks,
>
>Greg
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform