Hi,
I have a made a form on forms 11g. My form is based on dept table. I have one non-database block that i use for my toolbar.
I have three push buttons on my toolbar 1) Enter Query 2) Execute Query 3) Cancel Query.
Trigger (When-button-pressed ) on Enter Query
go_block('dept');
enter_query;
Trigger (When-button-pressed) on Execute Query
go_block('dept');
execute_query;
Trigger (When-button-pressed) on Cancel Query
go_block('dept');
abort_query;
When I execute the form and press the enter query push button the block gets cleared and cursor is at deptno. The status bar displays "Enter a query: Press Ctrl+F11 to execute, F4 to cancel"
I enter 30 and then press execute query push button. Nothing happens. If cancel query push button is pressed nothing happens and if I press F4 nothings happens
but if I press Ctrl+F11 then it fetches the record of dept no. 30.
Please help me where I am wrong or changes I have to make.? I could have used the default forms toolbar but I have many more buttons for other purpose, so I need to have my own custom toolbar.
Thanks