Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UPSize problem
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01064758
Message ID:
01064761
Views:
17
>Moving VFP data to SQL is via the Upsize wizard of VFP 9. How do you upsize empty 'date' fields to fill with nulls rather than '01/01/1900', yes 1900. I have tried all of the upsize options (step 8) and in all cases any empty 'date' field is populated with '01/01/1900' when it arrives in the SQL table. The upsize wizard uses the ODBC connection to connect with the sql server.
>
>Dallas

*If* I remember correctly - you can't. Its an issue with the ODBC driver - it doesnt let you pass .nulls. to SQL Server datetime fields.
ICQ 10556 (ya), 254117
Previous
Reply
Map
View

Click here to load this message in the networking platform