Home » Developer & Programmer » Forms » Count the number of records in a non database multirecord block (Oracle Forms 9i, Designer 9i)
Count the number of records in a non database multirecord block [message #420226] Thu, 27 August 2009 10:49 Go to next message
uttam.arya
Messages: 3
Registered: August 2009
Location: Netherlands
Junior Member

Hi,

Can somebody please help me with this? I tried without success Sad .I shall be really grateful. I need to display the number of records in a multirecord-block which is not bounded to the database. I can see in the tool tip menu that it shows for instance Records:3/5. I need to display the value 5 as total number of records at the moment when total number of records in that block is 5. Please see the attachment.

Regards,
Uttam
Re: Count the number of records in a non database multirecord block [message #420386 is a reply to message #420226] Fri, 28 August 2009 16:09 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps you could LAST_RECORD; then, :SYSTEM.TRIGGER_RECORD shows total number of records.
Re: Count the number of records in a non database multirecord block [message #420838 is a reply to message #420226] Wed, 02 September 2009 09:53 Go to previous messageGo to next message
TonyJaa
Messages: 50
Registered: May 2009
Member
hello,

Create a item with a summary function at "count" which counts a field of your block. this item will always contain the numbers of records.
Re: Count the number of records in a non database multirecord block [message #423032 is a reply to message #420226] Mon, 21 September 2009 20:07 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Good grief, use the 'count_query' facility in the 'pre-query' trigger.

David
Previous Topic: Turn off the Record Counter on the status bar of the MDI window.
Next Topic: Oracle Forms LAF Problem (merged 3)
Goto Forum:
  


Current Time: Wed Sep 28 19:27:16 CDT 2016

Total time taken to generate the page: 0.14328 seconds