Re: Ask help for oracle forms problem

No fair. Took me forever to learn ths stuff on my own... :-P

The Key-Others trigger disables all default keys. Then you enable the ones you want by creating the appropriate triggers.

eg: key-next: Next_record, etc...

Use Pre-Query trigger to set values to query on:

My_block/Pre-Query:
My_block.last_name := 'DOE';

You don't have to enter-query to execute_query;

Button: Query
When-button-pressed:
Execute_Query;

Now every time Query button is pressed, all records LAST_NAME = 'DOE' are fetched (actually anytime a query is executed these records are fetched.)

In article <362A1AC2.BDFBDE2F_at_cs.siu.edu>, Qiang Wu <wuqiang_at_cs.siu.edu> wrote:
>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
>
>
>
>

--
(: Joe Brown :)				      joe_at_apache.dtcc.edu
I believe Wine is going to be great if it ever gets finished. . .
I believe Linux _is_ great even though it's not finished! ! !
I believe you have my address.  :-)