Re: Oracle forms problem

1. you can use the set_default_where property of a base table block and then use the execute_query command.
2. easiest way to disable key triggers is to code them as null; eg KEY-F7 trigger containging the code 'null;'.
3. i don't really understand what you are asking in your 3rd question???

Qiang Wu wrote in message <362AC246.29F68F76_at_cs.siu.edu>...
>Hi,
> In oracle, when we want to execute a query, we must first enter a
>query, then execute query. Can we programmatically enter query?
>I mean,We use some code to explicitly change the value of some item,
>then run execute_query?
>
> Can we disable some key triggers? such as ctrl-f1, f7, f8,
>clear-form?
>
> Another problem is that when you input a form, you want to discard
>the current input, but the item has a trigger. Unless you have input a
>valid value, you can't leave that item field. Do we have a solution to
>discard the input at any time?
>
> Thanks in advance,
>
> Have a nice weekend,
>
>Qiang Wu
>
>
>
>
Received on Tue Oct 27 1998 - 00:21:07 CET