Re: Use Embedded SQL To Update A Date Field to Null

Hi
In regards to Tommy's question, the field is null-capable.  Using STRSQL, the following statement puts NULL in CDBUDGETDT.
 
UPDATE CADIST SET CDBUDGETDT = null WHERE CDAGID# = 1194
 
I could code that in the program, but then I also have to test for NULL.  Something like,
 
If  %nullind(BudgetDate) = *on;
     Exec SQL UPDATE CADIST SET CDBUDGETDT = null WHERE CDAGID# = 1194 ;
else;
     Exec SQL UPDATE CADIST SET CDBUDGETDT = :BudgetDate WHERE CDAGID# = 1194 ;
endif;
 
I gotta assume there's a better way than testing for NULL everytime. 
 
********************************
Friday, April 09, 2010 10:17 AM
 
is the date field null capable? if not then it won't matter what you try
it won't work...
 
Thanks,
Tommy Holden

*************************************************************************
Date: 04/09/2010 09:12 AM
Subject: Use Embedded SQL To Update A Date Field to Null

Hi
Has anyone managed to update a date field to *NULL using embedded SQL?

The code looks like:

clear BudgetDate;
  
 
*******************
In the archives, I found this example,
 
d NullInd...
d              s         5i 0
d                             Dim(2)
d                             Based(ptrNullInd)

 
Exec Sql Update FileY
          Set (CustName = :CustName :NullInd)
 
But that doesn't work either.  What am I missing?
 
Thank you    where CdAgid# = :Agid# ;        set CdBudgetDt = :BudgetDateExec Sql Update CaDist%nullind(BudgetDate) = *on;