I don't have SP3 (yet)
It only happens when I tableupdate(0) into the server.
My program does:
mydate = .null.
insert into tablea from memvar
tableupdate(0)
(this is just the relevant commands, there is a lot more to it, but I can throw a C5 error with the above code.)
>>>tablea.date -- I never populate it, it goes fine (by default, has a null value)
>>>tablea.date -- I put in .null. -- program throws a C5 error
>>>tablea.date -- I put in an empty date -- ODBC returns ivalid datetime type
>>>tablea.date -- I put in a valid date, it works fine.
>>>
>>>Grrr... I just spent two hours trying to figure that all out!
>>
>>Hi Todd,
>>
>>Interesting. I did a CREATE CURSOR FOO (mydate D), APPEND BLANK, and REPLACE mydate WITH NULL and didn't get a C5. What I did get was an error message saying that the field didn't accept null values. So I tried ISNULL() on the field and it returned .F. EMPTY(), however, returned .T.
>
>Addendum to this. This is with VFP 6.0 SP3.
--Todd Sherman
-Wake Up! Smell the Coffee!