Subject Re: [IBO] cascade relations
Author stanw1950
>
> * Make sure an ID is generated for newly inserted Classes and
> Class_Dances records. Use GeneratorLinks for both queries (I've
> explained how in an earlier post).
> Also make sure you have "before insert" triggers for both tables
> (and probably Dances too) that look like this:
>
> begin
> if ( New.Blah_ID is null )
> then New.Blah_ID = gen_id( Blah_Generator, 1 );
> end
>
> ...so the ID that IBO had generated, and inserted, will not be
> overwritten!
>

Paul,
If you use GeneratorLinks for your query, why do you need the before
insert trigger? How can the id be overwritten when it is only being
assigned by the GeneratorLinks in your query? Thanks.

Stan Walker