Re: Help on result of execute_query
Date: Wed, 14 Mar 2007 09:55:36 -0700
Message-ID: <1173891334.874927_at_bubbleator.drizzle.com>
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.orgReceived on Wed Mar 14 2007 - 17:55:36 CET