Determine record number in oracle forms

[chaticathe]

I am trying to determine the record number of a record in Oracle Forms so I can navigate to that record. I am using the code below but it only gives me the record number of the record I am currently displaying.

declare
temp_record number(40);
char_record varchar2(40);
Begin
temp_record := 0;
if :control.barcod e_query is null then
message('You must select a barcode.');
raise form_trigger_fa ilure;
end if;
go_block('prope rty');
char_record := null;
select :system.cursor_ record into char_record from property where barcode = :control.barcod e_query; (list box)
temp_record := to_number(char_ record);
go_record(temp_ record);
end;

[pritikumari]

You can achieve this by adding new item named 'ROWNUM'. in the Data Block you are working on. And it's 'BASE TABLE ITEM' property needs to be set as TRUE'. IN the property ,IN the post-query Trigger use
BEGIN
IF :SYSTEM.Cursor_ Record = '1'
THEN
MESSAGE ('At first record.');
END IF;
END;

Join Oracle Training In Noida.