Forms4.5: LAST_RECORD/Performance

From: Michael Irene <multipro_at_ix.netcom.com>
Date: 1995/06/28
Message-ID: <3ssnef$erh_at_ixnews3.ix.netcom.com>#1/1


I'm trying to add a "Goto Last Record" feature to a form containing a multi-record block. For large queries, using the LAST_RECORD function causes very long delays. Presumably, Forms is fetching all the records. Has anyone come up with a way to quickly fetch the last few records for a given query (dynamic -- sort order is user-selectable) into a block?

Is there a way to use the ROWID or ROWNUM to speed this process ?

Thanks in advance for any help!

--Mike     Received on Wed Jun 28 1995 - 00:00:00 CEST

Original text of this message