Home » Developer & Programmer » Forms » Help on execute_query
Help on execute_query [message #224362] Wed, 14 March 2007 01:36 Go to next message
Messages: 36
Registered: February 2006
Hi to All,

In a Form I have placed a button and the trigger WHEN_BUTTON_PRESSED has a code like this:

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

Is it 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. Embarassed

Thank You and Best Regards.
Re: Help on execute_query [message #224378 is a reply to message #224362] Wed, 14 March 2007 02:18 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
Oracle Forms has a vast variety of built-in functionality. If you don't want to use all that, why do you use Forms?
I really don't see the point in redefining Forms' default query-mechanism..
Previous Topic: How many records will fetch
Next Topic: how can i use the procedure as a date source
Goto Forum:

Current Time: Fri Oct 28 03:59:32 CDT 2016

Total time taken to generate the page: 0.17854 seconds