Home » Developer & Programmer » Forms » counting number of rows retrieved by query (6i and on ward)
counting number of rows retrieved by query [message #380874] Tue, 13 January 2009 12:16 Go to next message
Abdul Qadeer
Messages: 6
Registered: August 2007
Location: Peshawar
Junior Member
Dear friend!
Please help me for counting number of rows retrieved after "execute_query" and to store that number in text item.
I will be really grateful.
Re: counting number of rows retrieved by query [message #380876 is a reply to message #380874] Tue, 13 January 2009 12:47 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Read more about the COUNT_QUERY built-in in Forms Online Help System.
Re: counting number of rows retrieved by query [message #380924 is a reply to message #380874] Wed, 14 January 2009 02:01 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member


After

Execute_Query;
Begin
Count_Query;
End;

Javed
Re: counting number of rows retrieved by query [message #381022 is a reply to message #380924] Wed, 14 January 2009 22:00 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'count_query' and you will find http://www.orafaq.com/forum/m/362558/67467/?srch=count_query+david#msg_362558 which points to http://www.orafaq.com/forum/m/213673/67467/?srch=count_query#msg_213673 Read it!

David
Previous Topic: Pdf Viewer in Forms 10g
Next Topic: Read_Image_File
Goto Forum:
  


Current Time: Sat Dec 10 15:01:45 CST 2016

Total time taken to generate the page: 0.11477 seconds