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