| execute_query [message #77822] |
Wed, 28 November 2001 03:15  |
Joe
Messages: 138
Registered: November 1999
|
Senior Member |
|
|
Hi all,
2 questions:
a)which exception is thrown when "execute_query" returns no matches...the no_data_found exception doesn't work.
b)how can i get the number of returned records
thanx in advance
----------------------------------------------------------------------
|
|
|
|
| Re: execute_query [message #77823 is a reply to message #77822] |
Wed, 28 November 2001 04:11  |
Srinivas Konda
Messages: 29
Registered: October 2001
|
Junior Member |
|
|
1. You can use the following code to supress the "query caused no records to be retrived" message. I donot think it raises any exception.
:system.message_level := 5;
EXECUTE_QUERY;
:system.message_level := 0;
2. You can get the no. of records retuned by a execute_query by the following code.
EXECUTE_QUERY;
IF GET_BLOCK_PROPERTY('EMP',QUERY_HITS) > 0 THEN
MESSAGE('data found ');MESSAGE('data found ');
END IF;
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
