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