>>>I have a view of a MS SQL Server table. The view contains three datetime fields that I have defined in the view properties to be Date fields. When I modify a record or add a new record, and I leave these fields blank, VFP saves the date 01/01/1900 in these fields! I want them to remain empty!
>>
>>Generally speaking it is not VFP, it is MS SQL Server behaviour.
>
>Hi Nick,
>
>Thanks for the reply! I guess I'll have to add the additional code. However, I don't see how this can be a MS SQL Server problem. The problem does not occur when I use MS Query.
I don' really know what's happening at the back end in this case, but our Sybase guys told us that it is default behavior with empty date fields.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison