Try using triggers.

Christian Mautendorfer wrote:

>Hi,
>
>In my DB, when a record gets deleted I set a Status flag to mark it as deleted.
>The disadvantage is, that this makes server side referentail constraints
>useless
>in this context.
>
>So I was wondering if there is any call I can make to test if a record is
>deletable without
>it actually being deleted.
>
>TIA,
>
>--Chris
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus