Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Mohammed.

Asked: November 08, 2017 - 7:18 pm UTC

Last updated: November 09, 2017 - 2:07 am UTC

Version: Oracle forms 12

Viewed 1000+ times

You Asked

In oracle forms 12c, I created data block with tabula, I changed the otem row number displayed to 10 row,
I need to get current selected row no in this tabuler on form at run time not current_record, O mean this number between 1 to 10, I tried get otem instance propetry but I failed.
How can I do that?
Thanks,

and Connor said...

OK, it has been a *long* time since I've used Oracle Forms (like more than 10 years!) so please also check the Forums

https://community.oracle.com/community/development_tools/forms

But I think you can do:

t := GET_BLOCK_PROPERTY('MY_BLOCK', TOP_RECORD);
c := :SYSTEM.CURSOR_RECORD;

So lets say you have scrolled down to the 14th record in the block, so you can see records 8=>18 on screen.

't' will then be 8
'c' will then be 14

so from that we can deduce that you are on the 6th line on screen.

Hope this helps.

Is this answer out of date? If it is, please let us know via a Comment