Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Forms question

Re: Forms question

From: Maximus <qweqwe_at_qwqwewq.com>
Date: Fri, 06 Jun 2003 16:23:12 GMT
Message-ID: <Qd3Ea.163871$Vi5.4644951@news1.calgary.shaw.ca>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US