Suppose your remote view is rv_Company ( table is 'Company' )
Parameter is vp_names ( on 'name' field of 'Company' table)

let pass new value to your view....

vp_names = "Microsoft"
requery('rv_Company')

am in right ? Please write your code , so it would be more clear.

Thanks



>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