update a date to null

Hi, on Solaris 7, I4GL 7.1 this does not work update atable set (somedate) = (null) where state="CA" however, using ISQL the above would work, but in a compiled 4gl program it does not set the date field to null...it does not change the field at all. Is there some other way to set a date field to null?? -- original guitar music at http://www.mindspring.com/~nlymbo

Never Mind all, scratch that!! It is something else entirely. steveFarris wrote: > Hi, > > on Solaris 7, I4GL 7.1 this does not work > > update atable set (somedate) = (null) where state="CA"> > however, using ISQL the above would work, but in a compiled 4gl program > it does not set the date field to null...it does not change the field at > all. Is there some other way to set a date field to null?? > > -- > original guitar music at > http://www.mindspring.com/~nlymbo -- original guitar music at http://www.mindspring.com/~nlymbo

try this: update atable set acolumn = "" where state = "CA" "steveFarris" <nlymbo@mindspring.com> wrote in message news:39CA5FF6.8BB26B10@mindspring.com... > Hi, > > on Solaris 7, I4GL 7.1 this does not work > > update atable set (somedate) = (null) where state="CA"> > however, using ISQL the above would work, but in a compiled 4gl program > it does not set the date field to null...it does not change the field at > all. Is there some other way to set a date field to null?? > > -- > original guitar music at > http://www.mindspring.com/~nlymbo > >

Ray Margarella wrote: > try this: > > update atable > set acolumn = "" > where state = "CA" > Once upon a long time ago, that would have done the job. However, that will set Acolumn to blank in all modern versions of the server/I4GL. > "steveFarris" <nlymbo@mindspring.com> wrote: > > on Solaris 7, I4GL 7.1 this does not work > > > > update atable set (somedate) = (null) where state="CA"> > > > however, using ISQL the above would work, but in a compiled 4gl program > > it does not set the date field to null...it does not change the field at > > all. Is there some other way to set a date field to null?? -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN #include <disclaimer.h>