Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Easy Forms Question I think...
Try this:
if :system.mode = 'NORMAL' then
go_block('TESTING');
do_key('enter_query');
else
do_key('execute_query');
end if;
Hope this helps.
Jimmy wrote:
>
> Hello all,
>
> I have a Forms question.
>
> I have a table data block TESTING. All the fields in table TESTING
> are in this block.
>
> I developed a button with the following code:
>
> go_block('TESTING');
> if :system.mode = 'NORMAL' then
> do_key('enter_query');
> else
> do_key('execute_query');
> end if;
>
> i.e. to do a query. I press this button and it is OK (now in
> ENTER-QUERY mode). Then I press this button again to do the query,
> however, error message shown on the status bar (something like this
> function cannot performed here, press Ctrl-F1 to see a list of function)
> Could anyone tell me why such an error message occrus and how to solve
> this problem? (the Forms just have this block TESTING and this button,
> no other trigger).
>
> Thanks,
> Jimmy
--
Valeri Sorokine
Oracle Certified Application Developer, Rel.2
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 ; FAX: +7 (095) 234 0640
E-mail: vsorokin@dd.ru ; http://www.dd.ru
Received on Thu Oct 21 1999 - 09:09:11 CDT