RE: default value of a column and perform

Posted in 1999

Rick Rabe — Tue, 23 Nov 1999 10:54:42 -0600 — source: Informix-list mailing list archive (1991-1998)

I believe you'll have to add the defaults to your .per if I understand your question correctly. HTH > ---------- > From: Reinhard Habichtsberg[SMTP:Reinhard.Habichtsberg@unilux.de] > Reply To: Reinhard Habichtsberg > Sent: Tuesday, November 23, 1999 2:10 AM > To: informix-list@iiug.org > Subject: default value of a column and perform > > I defined a default value on a column. Inserting a new > row without specifying a value to that column sets > the value of the column to it's default value. > > That works if using a sql statement. > > Inserting a new column with a format generated with > perform (isql 7.20) left the value NULL. > > Is this a bug? > > Am I forced to specify constraints in the format-program? > > TIA > > Reinhard > >