General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Yes, Update All, Send SQL update and Share Connection in Advance Options has all been done. The data is being updated on the underlying Oracle table. The problem occurs when I change the parameters of the view and then Requery the the remote view. It's like the requery totally ignores the new parameter values. I can suspend the program, and manually enter in the new parameters from the command window and then browse the view and the data is not changed.
Thanks,
Greg
>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
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