checking before deleting a record required.

[essa2000]

Dear Programmers:
I am going to delete one record , I want to check that if this record has been used in other data , I mean it has been referenced in other table as a foriegn Key . Then before deleting the record it give me an error. I want to use this technique in a stored Procedure which is used to
delete the record.

Thanks in advance.

Regards ,
essa2000

 

[Ruairi]

if you try to delete a record that is being refrenced by a foreign key you will get an error and the delete will not happen. No programming is required for this. Ruairi
ruairi@logsoftware.com
Experienced with:

VB6, SQL Server, QBASIC, C(unix), MS Office VBA solutions

ALSO: Machine Control/Automation using GE and Omron PLC's and HMI(human machine interface) for industrial applications

 

[foxdev]

That is true if you have actually declared the referential integrity in the DDL, but not true if you have not.

You'll want a Delete trigger on the subject table that takes care of looking in the other tables for child records.

Robert Bradley

http://www.foxdev.com/