Current Record

[Elroacho]

I want to write a trigger to run on a huge table after an insert. I wanted to know if there is some way of picking up the record that caused the insert (i.e. the new record), rather than scan all the records, so I can decide if I want to copty certain fields into another table.

Cheers,
Kevin.

 

[PatrickIRL]

don't know if this will work in interbase but in SQL server if you are doing this in a transaction you have access to the INSERTED and DELETED virtual tables.

The way to access them is as normal ...

SELECT * FROM INSERTED

... or ...

SELECT * FROM DELETED

... will give you the records that were deleted or inserted. As I said, might be only an SQL Server thing but check it out.

Regards,

Patrick

 

[Elroacho]

I think interbase uses NEW and OLD in the same way SQL Server uses INSERTED and DELETED.

Cheers for your response.

YNWA,
Kevin.