| Number of Records Queried [message #83597] |
Wed, 05 November 2003 22:14  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
