Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server 7.0 defaulting to 1/1/1900
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
SQL Server 7.0 defaulting to 1/1/1900
Miscellaneous
Thread ID:
00278991
Message ID:
00278991
Views:
52
Using VFP 6.0 and a test database of 2000 records, I ran the Upsize wizard to push the data to SQL Server 7.0. All went well, but every date field that is empty (not NULL, just empty) in the VFP table defaulted to 1/1/1900 in the SQL table. Nulls was checked on for the SQL table, I chose NOT to upsize Indexes, Relations or Defaults. Any ideas?
Oct 31 = Dec 25
Next
Reply
Map
View

Click here to load this message in the networking platform