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 delete the
>>   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> My ALTER TABLE statement above will do exactly this.

CKL> It will delete activities when a job is deleted.  Try it in a test database.
 But also need delete activities!


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