Re: Help on result of execute_query

nick048 wrote:
> 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

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_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org