How to check up that has taken place UPDATE?
Leo asked how to detect which columns were updated, giving an MS SQL example using update(col1). Art S. Kagel pointed him to CREATE TRIGGER ... ON UPDATE OF in the Guide to SQL Syntax manual. Leo replied that this was not a full reference, and Claus Samuelsen then posted a link to the IDS 11.1 online help. No further outcome was given.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
How to check up that has taken place UPDATE?
Example to MS SQL :
if update(col1) or update(col2)
begin
insert into tab1(col1,col2) from deleted
insert into tab1(col1,col2) from inserted
endelse
insert into tab1(col1,col2) from inserted
end
Thanks,
Leo
Picaso.Leonardo@gmail.com wrote:
> How to check up that has taken place UPDATE?
>
> Example to MS SQL :
>
> if update(col1) or update(col2)
> begin
> insert into tab1(col1,col2) from deleted
> insert into tab1(col1,col2) from inserted
> end> else
> insert into tab1(col1,col2) from inserted
> end>
Leo:
Look up CREATE TRIGGER ON UPDATE OF ... in the Guide to SQL Syntax manual.
Art S. Kagel
Oninit
> Thanks,
> Leo
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
>
On 10 янв, 13:40, "Art S. Kagel (Oninit LLC)" <a...@oninit.com> wrote:
> Picaso.Leona...@gmail.com wrote:
> > How to check up that has taken place UPDATE?
>
> > Example to MS SQL :
>
> > if update(col1) or update(col2)
> > begin
> > insert into tab1(col1,col2) from deleted
> > insert into tab1(col1,col2) from inserted
> > end> > else
> > insert into tab1(col1,col2) from inserted
> > end>
> Leo:
>
> Look up CREATE TRIGGER ON UPDATE OF ... in the Guide to SQL Syntax manual.
>
> Art S. Kagel
> Oninit
>
> > Thanks,
> > Leo
> > _______________________________________________
> > Informix-list mailing list
> > Informix-l...@iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list
You could not give a full reference.
Best regards,
Leo
Picaso.Leonardo@gmail.com wrote:
> On 10 О©╫О©╫О©╫, 13:40, "Art S. Kagel (Oninit LLC)" <a...@oninit.com> wrote:
>> Picaso.Leona...@gmail.com wrote:
>>> How to check up that has taken place UPDATE?
>>> Example to MS SQL :
>>> if update(col1) or update(col2)
>>> begin
>>> insert into tab1(col1,col2) from deleted
>>> insert into tab1(col1,col2) from inserted
>>> end>>> else
>>> insert into tab1(col1,col2) from inserted
>>> end>> Leo:
>>
>> Look up CREATE TRIGGER ON UPDATE OF ... in the Guide to SQL Syntax manual.
>>
>> Art S. Kagel
>> Oninit
>>
>>> Thanks,
>>> Leo
>>> _______________________________________________
>>> Informix-list mailing list
>>> Informix-l...@iiug.org
>>> http://www.iiug.org/mailman/listinfo/informix-list
>
> You could not give a full reference.
>
> Best regards,
> Leo
http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp