Re: INSERT Trigger

Posted in 1998

Avi Abrami — Sun, 06 Sep 1998 08:45:15 +0300 — source: Informix-list mailing list archive (1991-1998)

Roland Pich'r wrote: > Hi > > I've got following problem: > > I want to use trigger to set current date in row which I just insert (in > the same table) > > Any ideas how to do this (or just 'no way - it's impossible') ??? > > Thanks, > > Roland Pichor > rpichor@ddc.daewoo.com.pl > > Roland, Instead of using an insert trigger, you can set the default value for the column to the current date. Check out the CREATE TABLE command in the SQL Syntax manual. HTH, Avi. ************************************************************************ /\\ \\ /| Avi Abrami, Analyst/Programmer, Telegate Ltd. /__\\ \\ / | 7 Haplada Street, Or-Yehuda, ISRAEL / \\ \\/ | Phone:+972-3-5388717 Fax:+972-3-5335877 eMail:avia@telegate.co.il