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_at_dd.ru   ; http://www.dd.ru