dbTalk Databases Forums  

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

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss Forms, record'CurrentRec'OF 'TotalRecs' what's the best way to get CurrentRec? in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
steve deno
 
Posts: n/a

Default Forms, record'CurrentRec'OF 'TotalRecs' what's the best way to get CurrentRec? - 02-25-2004 , 11:59 AM






All,

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

Reply With Quote
  #2  
Old   
Daniel Morgan
 
Posts: n/a

Default Re: Forms, record'CurrentRec'OF 'TotalRecs' what's the best wayto get CurrentRec? - 02-25-2004 , 05:25 PM






steve deno wrote:

Quote:
All,

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
In my forms the numbers show up in the lower left corner of the window
on the status bar? Did you disable the default?

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)



Reply With Quote
  #3  
Old   
steve deno
 
Posts: n/a

Default Re: Forms, record'CurrentRec'OF 'TotalRecs' what's the best way to get CurrentRec? - 02-25-2004 , 11:50 PM



I did not disable the default, but would I not have to query all
records in the block to get the total number of records to show up?

Also, I wanted to be able to show multiple counts for each block
displayed

Daniel Morgan <damorgan@x.washington.edu> wrote

Quote:
steve deno wrote:

All,

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

In my forms the numbers show up in the lower left corner of the window
on the status bar? Did you disable the default?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.