Re: Forms4: Cursor or Record Group?
From: Gary John Walker <gjwalker_at_gjw1992.demon.co.uk>
Date: Sat, 26 Mar 1994 02:11:37 +0000
Message-ID: <764647897snz_at_gjw1992.demon.co.uk>
Date: Sat, 26 Mar 1994 02:11:37 +0000
Message-ID: <764647897snz_at_gjw1992.demon.co.uk>
In article <2a076006_at_f573.n115.z1.fidonet.org>
Michael.Stowe_at_f573.n115.z1.fidonet.org writes:
>
>Yes, actually. Your where clause for the LOV for the second item should
>contain something like the following:
>SELECT ITEM2 FROM TABLE
> WHERE ITEM1 := :BLOCK.ITEM1;
Is the ' := ' intended? With a WHERE ITEM1 = :BLOCK1.ITEM1, the
first time I use that record group, the value of :BLOCK1.ITEM1
is used. Thereafter - that SAME value for :BLOCK1.ITEM1 is also
used. Even if I reenter something else in :BLOCK1.ITEM1.
I'll try again ...!
> WHERE ITEM1 := NVL(:BLOCK.ITEM1, ITEM1);
>
v useful - thanks.
Gary John Walker gjwalker_at_gjw1992.demon.co.uk -------------------------------------------------Received on Sat Mar 26 1994 - 03:11:37 CET