Hi,
I would like to be able to figure out if a table has
been updated in this connection from within a C
trigger.
I have already tried to the use a query with currval
on the autoincremented primary key but that exits the
trigger with
table.currval is not yet defined in this session
Is there a way to trap / ignore this error? Or a way
to check if there was a transaction in this connection
before.
Thanks for any input.
Best wishes,
M
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com