469,623 Members | 1,850 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,623 developers. It's quick & easy.

Determine record number in oracle forms

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.barcode_query is null then
message('You must select a barcode.');
raise form_trigger_failure;
end if;
go_block('property');
char_record := null;
select :system.cursor_record into char_record from property where barcode = :control.barcode_query; (list box)
temp_record := to_number(char_record);
go_record(temp_record);
end;
Aug 16 '06 #1
0 5666

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

12 posts views Thread by Martin Heuckeroth | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.