Re: Just one little simple question

From: Jochen Van den Bossche <Jochen.Van-Den-Bossche_at_eurocontrol.be>
Date: Fri, 18 Dec 1998 08:31:15 +0000
Message-ID: <367A12D3.3241_at_eurocontrol.be>

Greg Williams wrote:
>
> What PL/SQL code would I use to simulate a physical interaction of the
> the following?
>
> Pressing the toolbar button to 'Enter Query', choosing an item from a
> list called Project_ID, then pressing the button to 'Execute Query'?
> How can I do this programatically?
>
> Thanks.

What do you mean by "choosing an item from a list called Project_ID"? Is that a List Of Values (LOV) attached to an item called Project_ID? Or is it a List Item called Project_ID?

Any way, I have allready done this:

• IF System.Mode = 'NORMAL' THEN Enter_Query; -- 1 :emp.id := emp_id_variable; -- 2 Execute_Query; -- 3
• END IF;

The IF is for preventing execution of the trigger when you allready are in enter query mode.
1 opens the enter query mode.
2 assigns a value to a field. Since this is done in enter query mode, it becomes a query condition.
3 executes the query.

PS.
It was a long time ago I used this. I remember that there was a problem with assigning a value to create a query condition (so this might not work completely), but than again the functionality we were designing was more complicated than this example: The value was retrieved from another form... Received on Fri Dec 18 1998 - 09:31:15 CET