How to add navigation buttons to an Oracle form.

[fmasin]

Hi,

I have added two buttons to my form;

For Adding records and clearing the form:

The Add trigger is as follows: Begin
Commit; End;
The clear_form: Begin clear_form; End;

I would like to add buttons to go to next record and go back to Previous record. What is the syntax for the triggers? Please help.








Thanks and regards,

Francis

 

[R1972]

NEXT_RECORD or GO_RECORDSYSTEM.CURSOR_RECORD + 1) for next record.

PREVIOUS_RECORD or GO_RECORDSYSTEM.CURSOR_RECORD - 1) for previous record.

Check the block for the buttons.