ODBiC Discussion Board


RE: I'd need to see exactly what you are trying to do, Roger Harris, 04-01-2007

Found alternative answer

by Jong, April 2, 2007 02:59

Thanks for reply, I tried your suggestions but no success. This also does not seem to accept null entries to clear a date. I found that the code below works, so I am happy with that.

if len($ContractReviewDate$)=0;
   xContractReviewDate=null;
else;
   xContractReviewDate="'$ContractReviewDate$'";
endif;

UPDATE MasterISIR SET ContractReviewDate=$xContractReviewDate$, etc. etc.



Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


Copyright ©1997-2003, Roger Harris. All rights reserved.