Re: Question

Hello Christopher,
 I don't need delete record from jobs when I delete record from activity. But I need delete record from activity when I
deletethe record from jobs and I need to find this job_id in activities table! What must I do?
 

CKL> Question: Why don't you just set up a foreign key that will achieve exactly
CKL> the same thing without using RULEs?

CKL> ie. ALTER TABLE activities ADD FOREIGN KEY (job_id) REFERENCES jobs(job_id)
CKL> ON DELETE CASCADE;

CKL> Chris

>>   I have the rule for table
>>   CREATE RULE del_jobs_del_activity AS ON DELETE TO jobs DO
>> DELETE FROM activities WHERE job_id = OLD.job_id;
>>
>>   When i call:
>>   DELETE FROM jobs WHERE job_id IN (SELECT DISTINCT job_id FROM
>> activities WHERE load_no = OLD.load_no)
>>   This query does not delete the record from jobs but delete the
>>   record by rule.

Best regards,Andriy                            mailto:andriy.pyrozhenko@vanjaonline.com