Forms 4.5 :block.item returns the wrong value

From: Sean McMurray <>
Date: Tue, 04 May 1999 12:41:46 -0700
Message-ID: <>

[Quoted] [Quoted] I have a control block (CTLBLK) with three drop-down list controls (DDL1, DDL2, DDL3).
Each list is populated from a query-based record group.
The query for DDL1's record group is a constant.
The query for DDL2's record group depends on the value in DDL1.
The query for DDL3's record group depends on the values in DDL1 and
DDL2. When a change is made in DDL1, DDL2 is re-populated. When a change is made in DDL1 or DDL2, DDL3 is re-populated.

With a change to any of the three lists, I edit the DEFAULT_WHERE property for another block (OTHERBLK) based on the values of the three lists.

Now here's the problem.

When I select a value in DDL1, I repopulate DDL2 and DDL3, then set_block_property('OTHERLK', DEFAULT_WHERE, 'col1=''' || :CTLBLK.DDL1 || ''' and col2=''' || :CTLBLK.DDL2 || ''' and col3=''' || :CTLBLK.DDL3 || ''' ');

This statement is returning the old values (before the lists were repopulated) for DDL2 and DDL3.

Why, and how do I fix it? Received on Tue May 04 1999 - 21:41:46 CEST

Original text of this message