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>


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

Original text of this message