Re: Traversing BLOCK Items

From: <igal_at_healthstreet.com>
Date: Thu, 07 May 1998 09:10:57 -0600
Message-ID: <6isfdh$nsv$1_at_nnrp1.dejanews.com>


In article <355198F8.5058_at_domain-tech.com>#1/1,   Ed Jennings <jenningse_at_domain-tech.com> wrote:
>
> I'm using FORMS 4.5 on an NT platform. I have a FORM that
> contains a MASTER Block and two DETAIL Blocks. At query time,
> I want to be able to check the value of all ITEMS in all of
> the blocks so that I can record the query criteria for
> auditing purposes. Capturing the query string itself via
> :SYSTEM.LAST_QUERY was useless since it only displays the
> bind variables and not the actual values. Is there a
> straight forward way to programatically traverse through
> all of these items, including the DETAIL Blocks, to check
> for NOT NULL values?
>
> TIA
>
> Ed Jennings
>
> --
> The opinions expressed here are my own, not those of Domain Technologies
>

Hi Ed,
You can do that by looping through all items in all blocks using the GET_BLOCK_PROPERTY([block id],NEXBLOCK) and GET_ITEM_PROPERTY([item id],NEXTITEM) built ins.

Igal.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu May 07 1998 - 17:10:57 CEST

Original text of this message