Home » Developer & Programmer » Forms » Number of Records Queried
Number of Records Queried [message #83597] Wed, 05 November 2003 22:14 Go to next message
sapna
Messages: 5
Registered: September 2002
Junior Member
Hi How can I get the number of records queried after executing the query? I tried GET_BLOCK_PROPERTY('BLK_NAME',QUERY_HITS). But is not working. I'm using ORacle Data base. Depending on the number of records retrieved I want to set the colors. Pls Help
Re: Number of Records Queried [message #83600 is a reply to message #83597] Thu, 06 November 2003 01:12 Go to previous message
sameer_am2002
Messages: 129
Registered: September 2002
Senior Member
DECLARE
no_of_rec number ;
BEGIN
no_of_rec := get_block_property('GROUP_1', QUERY_HITS) ;
END;
write this code in post-query . Be sure to make block property query_All_records to yes.
Previous Topic: Case statements
Next Topic: urgent: please help me with 9i web form issue
Goto Forum:
  


Current Time: Sat Aug 13 00:41:06 CDT 2022