>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.
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
