Re: Forms 4.5 question

From: Jan Vanparys <Vanparys.Jan_at_village.uunet.be>
Date: Tue, 6 Oct 1998 20:12:34 +0200
Message-ID: <6vdmk7$9f7$1_at_xenon.inbe.net>


Why don't you update the table used in BLOCKB (using UPDATE) and then simply re-query BLOCKB ?

Greetings
Jan Vanparys
Belgium

Lisa F. Miller heeft geschreven in bericht <361A11AF.66364A7B_at_ornl.gov>...
>I have 2 blocks, BLOCKA & BLOCKB, which have a one-to-many
>relationship. BLOCKB is a multi-record block. If the value of item
>BLOCKA.FIELD1 changes, I need to recalculate value BLOCKB.FIELD1 for
>every record row in that block. Does anyone know of a way to deal with
>each record row in a multi-record block without actually navigating to
>that block? If I update BLOCKB.FIELD1 when the
>BLOCKA.FIELD1-POST_CHANGE trigger, I can only update the first record in
>BLOCKB. I cannot navigate to BLOCKB to loop thru the records there
>because "any built-in routine that initiates navigation is
>restricted...and are illegal in triggers that fire in response to
>navigation". Is there another way to determine that BLOCKA.FIELD1 has
>changed so that I can navigate to BLOCKB? Is there a way to mass change
>records in BLOCKB without actually being in BLOCKB? Any help would be
>appreciated.
>
>Thanks,
>Lisa
>
Received on Tue Oct 06 1998 - 20:12:34 CEST

Original text of this message