>>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.
George
Ubi caritas et amor, deus ibi est