Re: TRICKY TRIGGER QUESTION
From: Pablo Sanchez <newsrdr_at_mew.corp.sgi.com>
Date: 1997/08/07
Message-ID: <5sd8c8$152_at_mew.corp.sgi.com>#1/1
> I need to capture primary key changes. Let's say, my update statement
> changes primary key of 10 rows (assumeing primary key as int, values
> 1, 2, 3...10 and new values are 1101, 1102, 1103, ... 1110), then I want
Date: 1997/08/07
Message-ID: <5sd8c8$152_at_mew.corp.sgi.com>#1/1
In article <870965629.3791_at_dejanews.com>, sprajapa_at_fmrco.com writes:
>
> I need to capture primary key changes. Let's say, my update statement
> changes primary key of 10 rows (assumeing primary key as int, values
> 1, 2, 3...10 and new values are 1101, 1102, 1103, ... 1110), then I want
Doesn't it sound intrinsically wrong to be changing a primary key?
If yur changing it, it ain't primary.-- Pablo Sanchez | wk: 415.933.3812| pg: 800.930.5635 -or- pablo_p_at_pager.sgi.com --------------+-----------------+-------------------------------------------- pablo_at_sgi.com ... when mailing me, place "not spam" in the SubjectReceived on Thu Aug 07 1997 - 00:00:00 CEST