Thanks a lot, Trey.
>The ODBC connection to VFP also does not deal with empty dates, so it puts the standard empty date value in - Dec 30, 1899.
>Besides, if you're moving to SS or Oracle, you will have to work with NULL values in date fields as there is no such thing as an empty date in these.
>Either that or check for Date=Dec 30, 1899. As for me, ISNULL() works just as well, since the standard "empty" date may change. SQL 6.5 it was January 01, 1900.
>
>>I'm developing an application with remote views, odbc and for database source VFP (later we'll test wuith Oracle and SQL Server).
>>Every time i recall items with an empty date, comes to me as '30/12/1899', not as empty date.
>>Also i'm not able to validate a record with and empty date. Tableupdate returns an error if i left a date field empty. I don't want to work with null values but with empty values.
>>Working with VFP in local mode this works fine but with remote views not.
>>¿Any ideas?
>>TIA
Saludos,
A.G.P.
---------