Re: SQL - Trigger
Posted in 2000
Topics: Triggers, Constraints & Referential Integrity
--------------305DEBFAD55DFBFF0F5F06A6 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit You can't change inside a trigger the data in the triggered table Liat Tom wrote: > Hi, > > I have trigger on insert. Is this possible to change (by this trigger) 1 > column in record which is inserted? > Thanks for all answers > > Tom --------------305DEBFAD55DFBFF0F5F06A6 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> <font size=+2>You can't change inside a trigger the data in the triggered table</font><font size=+2></font> <p><font size=+2>Liat</font><font size=+2></font> <p><font size=+2>Tom wrote:</font> <blockquote TYPE=CITE><font size=+2>Hi,</font><font size=+2></font> <p><font size=+2> I have trigger on insert. Is this possible to change (by this trigger) 1</font> <br><font size=+2>column in record which is inserted?</font> <br><font size=+2>Thanks for all answers</font><font size=+2></font> <p><font size=+2>Tom</font></blockquote> <font size=+2></font></html> --------------305DEBFAD55DFBFF0F5F06A6--