Forms, record'CurrentRec'OF 'TotalRecs' what's the best way to get CurrentRec?

From: steve deno <sldcrew2k_at_yahoo.com>
Date: 25 Feb 2004 09:59:47 -0800
Message-ID: <8e6b14d8.0402250959.33728e3d_at_posting.google.com>



All,

[Quoted] [Quoted] I have seen this question talked about a few times in the archives, but I'm looking for more oppinion.

In Forms 9i I need to display the current record number and the total count of records in a block. For the total, I just did the "precompute-summary-count thing", which works fine. Now the user also wants to always know what record they are on. I was originally thinking along the lines of doing a when-record-chnged, or when-new-item-instance trigger that would put the :system.cuurent_item into a variable. Would this make sense? I have to other constraints that make me want to look for a better way. First, I don't want to query all records because there could be many. Second, this block has dynamic sorting applied which I was thinking could get in the way.

Is there a "standard" way of doing this?

Thanks for the help,

steve Received on Wed Feb 25 2004 - 18:59:47 CET

Original text of this message