Hi to all,

In a Form I have placed a button. in the trigger WHEN_BUTTON_PRESSED I
have a code that:

1) create a WHERE string (LC$Whr) with some filter Items, initialized
in the Header block;
2) after use this statement:
Set_Block_Property( 'MYBLOCK', DEFAULT_WHERE, LC$Whr ) ;
Go_Block('MYBLOCK');
Execute_Query ;

It is possible to control if the query return a valid search ?
In other words I need this:
If the Select in the Execute_query has found record(s) then display
the Canvas with the Data Block found, else display an Alert message.

I hope yes, but I don't know as.

Thank You and Best Regards.
Gaetano

nick048 wrote:
You could run a WHERE ... EXISTS to see if there is anything that
corresponds and then either run the real query or pop up the alert.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org