Hi all,

I am busy developing an accounts package in Firebird. Because of the nature
of the application, I have decided to institute strict referential
integrity, and have started by creating tables with foreign keys, cascade
updates, etc., etc., etc.

In Sybase, I could write a trigger that would fire before a delete, that
would check to see if there were any records dependant on the FK. If there
were, it could prevent the delete and pass the user an error message.

How would I do the same in FB?

Thanks

Tim


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