Re: How to determine record/item number in a multi-record block

Unless you have a column that states the record number (a serial numer of sorts, I guess), you are stuck with dealing with rownum, which is not all that flexible (but it works!). Look at the user's guide for ROWNUM.

"Steve E." <steve.eckersley_at_ITS.lancscc.gov.uk> wrote in message news:3a9b9163$1_at_news.norweb.net...
> Hello,
> I have a forms 5 application running over our local intranet and for
 one
> of the forms I would like to determine which physical record/item the
 cursor
> is in in a multi-record block i.e. I have 10 reords displayed at once but
> the record number returned by system.cursor_record is not necessarily the
> same as the physical record/item number that the record is in, e.g if the
> query returned 30 records and the user scrolled down to record number 25
> this would be the last record displayed, physical record 10, and if the
 user
> then scrolled back up the page the record number and physical record
 number
> will continue to be out of sync until the cursor reaches the first record.
> Any suggestions?
> Thanks
> Steve E.
>
>
Received on Wed Feb 28 2001 - 18:39:59 CET