Suppose there was a view A of 2 tables B & C where both B & C have
auto-increment triggers on them. If I write a before insert trigger for A
that looks like this:

Set Term ^ ;

Create Trigger "A_Before_Insert" for "A"
Active Before Insert As
Begin
/* My autoIncrement triggers update if -1 */
New."B_AI_KeyField" = -1;

Insert Into "B"
Values (New."B_AI_KeyField", ...);

Insert Into "C"
Values (New."C_AI_KeyField", B_AI_KeyField, ...);
End
^

Set Term ; ^


Will the value of New."B_AI_KeyField" be changed to the correct key value
after inserting into B or do I have to do a Select Into to retrieve the
correct key value?

R.

[Non-text portions of this message have been removed]