I have table A and I have programmed an INSERT Trigger for that.
This TRIGGER inserts in table B a row.
the ID from table B.
Question: How can I get the ID from table A ??
Thanks a lot!!!
Hope this help,
> I have table A and I have programmed an INSERT Trigger for that.
> This TRIGGER inserts in table B a row.
> the ID from table B.
> Question: How can I get the ID from table A ??
> Thanks a lot!!!
I have a database being developed that now requires me to insert entries
into another table from a trigger when an insert occurs on the main table.
(The clients changed the spec during development... AAARRRGH)
being inserted as the trigger is adding information after the original
insert so my original entries identity is lost.
I have read through the NG and noticed solutions for SQL2000 but I am
developing on SQL7 which does not have the extra variables that should have
been in place well before SQL2000.
Anyone have any ideas how to code around this.