Home » Developer & Programmer » Forms » Get Total number of records (10g form builder,11gdb)
Get Total number of records [message #583719] Fri, 03 May 2013 06:36 Go to next message
ora_bbm
Messages: 30
Registered: March 2013
Location: Chennai
Member
hai...
I have a multi record field of five rows. And 3 values.
the values are
IT
CSE
ECE

And i have one text item name is COUNT.
My need is how to show the total number of records in Text item .

Report message to a moderator

Re: Get Total number of records [message #583720 is a reply to message #583719] Fri, 03 May 2013 06:38 Go to previous messageGo to next message
cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester
Senior Member
Forms shows the number of rows in the block at the bottom of the screen by itself. Why do you need to do anything?

Report message to a moderator

Re: Get Total number of records [message #583721 is a reply to message #583720] Fri, 03 May 2013 06:40 Go to previous messageGo to next message
ora_bbm
Messages: 30
Registered: March 2013
Location: Chennai
Member
i want to show manually.... anything is here to hide that message

[Updated on: Fri, 03 May 2013 06:45]

Report message to a moderator

Re: Get Total number of records [message #583722 is a reply to message #583721] Fri, 03 May 2013 06:47 Go to previous messageGo to next message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Navigate to multirecord block's last record. :SYSTEM.CURSOR_RECORD shows the current record number. Put that value into your COUNT item.

Report message to a moderator

Re: Get Total number of records [message #583724 is a reply to message #583722] Fri, 03 May 2013 06:52 Go to previous messageGo to next message
ora_bbm
Messages: 30
Registered: March 2013
Location: Chennai
Member
I put the below coding.
:COUNT := :SYSTEM.CURSOR_RECORD;

But it will show only one record is there...but here 3 record is there

Report message to a moderator

Re: Get Total number of records [message #583727 is a reply to message #583722] Fri, 03 May 2013 06:59 Go to previous messageGo to next message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Littlefoot
Navigate to multirecord block's last record.

Did you do that?

Report message to a moderator

Re: Get Total number of records [message #583728 is a reply to message #583727] Fri, 03 May 2013 07:01 Go to previous messageGo to next message
ora_bbm
Messages: 30
Registered: March 2013
Location: Chennai
Member
:count :=:system.trigger_record;
This shows when i navigate the multirecord's fields of last record.
but i want when i executing a query it will shows the total number of records is there.
For example from my question is total record 3

[Updated on: Fri, 03 May 2013 07:07]

Report message to a moderator

Re: Get Total number of records [message #583729 is a reply to message #583728] Fri, 03 May 2013 07:06 Go to previous messageGo to next message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I can try in Croatian, if you want, but I'm afraid you wouldn't understand it either. So, let me try once again: did you navigate to multirecord block's last record?

Report message to a moderator

Re: Get Total number of records [message #583730 is a reply to message #583729] Fri, 03 May 2013 07:19 Go to previous messageGo to next message
ora_bbm
Messages: 30
Registered: March 2013
Location: Chennai
Member
:count :=:system.trigger_record;
This shows when i navigate the multirecord's fields of last record.
but i want when i executing a query it will shows the total number of records is there.
For example from my question is total record 3

Report message to a moderator

Re: Get Total number of records [message #583731 is a reply to message #583730] Fri, 03 May 2013 07:25 Go to previous messageGo to next message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
i want when i executing a query it will shows the total number of records is there

As far as I can tell, there's no built-in function that does that. Therefore, you have to do that by yourself, writing some code. LAST_RECORD built-in procedure moves you to the last record in a block. This is what I had on mind when saying that you should navigate there - use LAST_RECORD. Once you're there, :SYSTEM.CURSOR_RECORD tells you where you are (i.e. it returns record number for a record where the cursor is).

Report message to a moderator

Re: Get Total number of records [message #583787 is a reply to message #583731] Sat, 04 May 2013 01:22 Go to previous message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member
Dear,
Quote:

:count :=:system.trigger_record;
This shows when i navigate the multirecord's fields of last record.
but i want when i executing a query it will shows the total number of records is there.
For example from my question is total record 3


Please Have a Look http://www.orafaq.com/forum/mv/msg/159226/465202/81953/#msg_465202
It'll help you.

Regards,
Irfan

[Updated on: Sat, 04 May 2013 01:22]

Report message to a moderator

Previous Topic: foms 6i - getting ora-00928 missing select keyword ora-06512 at"package.procedure_name" at line
Next Topic: Update field based on another field check box
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 22:08:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.