Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Forms question
"Maximus" <qweqwe_at_qwqwewq.com> wrote in message
news:tC2Ea.140577$ro6.4190237_at_news2.calgary.shaw.ca...
> How I can get the offset to the current record in a multi-record block?
>
> For example, I have a multi-record block of ten rows. If the first
visible
> record is #17 and the current record is #21, then the current record has
an
> offset of 4 from the first visible record.
>
> The only system variable I can find that provides an offset is
> SYSTEM.MOUSE_RECORD_OFFSET... unfortunately it only works with mouse
input.
>
> Any ideas? I'm using forms90.
Disregard that question, figured out a solution:
offset := get_block_property('block',CURRENT_RECORD) - get_block_property('block',TOP_RECORD) + 1; Received on Fri Jun 06 2003 - 11:23:12 CDT