How to retain block position after a re-query -oracle forms
Hi All,
How to retain block position after a re-query -oracle forms
I have an oracle custom form (Oracle forms 6i OR 10g) with a data block (Multi row) which displays 100 items.
On the form I have a scrollbar and a checkbox . When an item (a row) in the data block is selected by checking the Check box, and the 'Approve' button
is pressed, it Approves the selected item from the database and then re-querying the data.
By default, this returns the user to the top of the list. I am trying to navigate to the record that just approved. This can be done using the GO_RECORD(number) Built in Function(BIF) (assuming number is the saved value of :System.cursor_record).