When the user selects Save, are you checking the return value from the TABLEUPDATE()?
>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
Chris McCandless
Red Sky Software