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.
Name E-mail optional TopicMessage:
HTTP Link: Link text: