| Help on execute_query [message #224362] |
Wed, 14 March 2007 01:36  |
nick048
Messages: 36
Registered: February 2006
|
Member |
|
|
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 ) ;
Go_Block('MYBLOCK');
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. 
Thank You and Best Regards.
Gaetano
|
|
|
|
| Re: Help on execute_query [message #224378 is a reply to message #224362] |
Wed, 14 March 2007 02:18  |
Frank
Messages: 7901
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..
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
