Technology Stack - EBS (MOSC)

MOSC Banner

How to retain block position after a re-query -oracle forms

edited Aug 20, 2021 10:59AM in Technology Stack - EBS (MOSC) 3 commentsAnswered

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).

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center