OraFAQ Forum: Forms » Count the number of records in a non database multirecord block

Home » Developer & Programmer » Forms » Count the number of records in a non database multirecord block (Oracle Forms 9i, Designer 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Count the number of records in a non database multirecord block [message #420226]

Thu, 27 August 2009 10:49

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

Report message to a moderator

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

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Perhaps you could LAST_RECORD; then, :SYSTEM.TRIGGER_RECORD shows total number of records.

Report message to a moderator

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

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.

Report message to a moderator

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Good grief, use the 'count_query' facility in the 'pre-query' trigger.

David

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:44:10 CDT 2024