update a date to null
steveFarris reported that in I4GL 7.1 on Solaris 7 an UPDATE setting a date column to null worked in ISQL but not in a compiled 4GL program. He then said to scratch it because the cause was something else. Ray Margarella suggested setting the column to an empty string; Jonathan Leffler said that once worked but in modern versions it sets the column to blank. Unresolved publicly.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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>