Re: Simulate sequence on WHEN-CREATE-RECORD
From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Sat, 20 Dec 2003 21:04:05 +0100
Message-ID: <eh49uvgtmr2v868vmo403gcdnhegmr9kn6_at_4ax.com>
Date: Sat, 20 Dec 2003 21:04:05 +0100
Message-ID: <eh49uvgtmr2v868vmo403gcdnhegmr9kn6_at_4ax.com>
On Fri, 19 Dec 2003 16:39:25 -0800, "Aaron V" <Tinkerist_at_hotmail.com> wrote:
>But, if I were to use a BEFORE INSERT trigger
>in the database and had a Master-Detail Relationship on the form (which I
>have), you'd have to commit, then re-query the master info before creating
>any detail records. Or the detail records would have a null Foreign Key, So
>I put the code in the Pre-Insert Trigger at the Block Level, and it seems to
>be fine, although I may also put a DB trigger for input from other sources.
If you setup the detail block correctly you won't need to commit and you won't need to requery
-- Sybrand Bakker, Senior Oracle DBAReceived on Sat Dec 20 2003 - 21:04:05 CET