Re: Forms4.5 Question

In <zhou.807557127_at_maotai> zhou_at_igd.fhg.de (Zhou Jian) writes:
>
>hi,
>
>I wonder how to modify the FROM clause dynamically, for
>example, in a PRE-QUERY trigger?
>
>In my form application, I have a base table block. When I
>issue a query for this block, the FROM clause contains
>only the base table's name. However, I need to expand
>the Where clause to include a join with other tables
>in a PRE-QUERY trigger. So I have to
>expand the FROM clause accordingly to include tables
>used in join.
>
>Is there any possibility to modify the FROM claus dynamically?
>
>I tried to modify the :System.Last_Query, but was told that this
>system variable can not be modified.
>
>Thanks for your help.
>
>Jian Zhou
>
>

>|___|___|_|_|_|_| Fraunhofer Institute for Computer Graphics
 

>| | |_|_|_|_|
 

>|___|___|_|_|_|_| Jian Zhou email : zhou_at_igd.fhg.de
 

>| /--- / /---| Wilhelminenstr. 7 phone : (+49) 6151-155-131
 

>| /-- /_ / __ | D-64283 Darmstadt fax : (+49) 6151-155-199
 

>|/ / / /___/ | Germany
 

>|_______|_______|_____________________________________________________
 ___|
>
>

Hi,

    This may Help U.
If you know all the tables you need to access , you can change the where clause of block at the runtime using SET_BLOCK_PROPERTY. The property is DEFAULT_WHERE. you can specify your table needs.
I hope this will help you

Swapan Jha
jhas_at_ix.netcom.com (USA) Received on Fri Aug 04 1995 - 00:00:00 CEST