>i am using a SQL Server database.
>
>i have a view that reformats a sql - datetime datatype to a vfp date datatype.
>
>the default value in sql is null. when i save a record with an empty date it is automatically saved as 01/01/1900.
>
>is their a way to get around this problem. it may be something with ODBC, but we are not sure.
>
>tia
>frank
Blank dates are different than NULL dates. When VFP adds a new record, the value in the date field is empty, not NULL. When the view passes it back to SQL, the empty date gets translated. Make sure the date field in the view is set to NULL. You can replace the value explicitly or create a default value for it.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao