Just a different approach ...
How about inserting a record in a table on insert, with a timestamp,
identifying the row that was inserted and requires validation. Your
validation process could then be a job, that runs every x minutes,
selecting records that are older then 20 seconds, and firing up an
email if some condition is met. It could end by deleting processed
records.
You would not even need this extra record/table if the inserted row had
a "insert timestamp".
Received on Thu Aug 10 2006 - 13:02:34 CDT
