At 01:07 PM 08-12-01 +0000, you wrote:

>Hi,
>
>How can I prevent that a certain record will be deleted from a table
>(table1) as long as in other tables (table2) there is still a
>reference to the PK of this record.
>
>I thought this was possible with Foreign keys, but it seems I can
>only set how the still existing records (table2) have to change.

The default referential integrity constraint is to disallow deletion of a row if it has dependent rows. The ON DELETE CASCADE clause in the foreign key declaration overrides this default behaviour. Just omit it.

Helen

>Thanks, Tom.
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________