Refresh the data block with the existing data w/o Execute Query.
FormsApr 10 2008 — edited Apr 26 2008Hi All,
I do have a block. I am giving the user to do manipulations based on Enter Query, where they restrict the data block to some data and perform some manipulation.
I have a Save Button in Which I perform Commit_form and also Call one procedure.
The procedure, tries to update the records on the table, which is currentlu on the block. After this when I try to update the data which got updated by the procedure, it says that the data is updated by another user. Requery.
Now I can see the refreshed data by giving execute query after the procedure call. But it brings me all the records in the table. But I need to see the refreshed records which was selected by the user's Enter query. Is there any way to achieve it?