Re: How to update

Peloux wrote:

> Hi,
> In a table i have a parent child relation :
>
> ID Name Description ParentId
> 1 data1 Description1 Null
> 2 data2 Description1 1
> 3 data3 Desscription1 1
>
>
> I would like to update child data when i update parent data with a
> trigger.
> Ex: If I update the description of the first line (ID=1), I would like
> that the rows referencing this line (parentId=1) has been updated !
>
>
> How can i do ?
>
> Thanks,
> Olivier

Great. So what's the problem? Just use a BEFORE UPDATE trigger.

Or do you want someone here to do your homework for you and write it too?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)