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 .
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: 10573
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?
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: 18834
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.
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
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: 18834
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Littlefoot
Navigate to multirecord block's last record.

Did you do that?
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: 18834
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?
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
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: 18834
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).
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: 522
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:
  


Current Time: Mon Apr 21 05:54:51 CDT 2014

Total time taken to generate the page: 0.08654 seconds