How to check up that has taken place UPDATE?

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