Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error converting date to SQL datetime
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Error converting date to SQL datetime
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01184352
Message ID:
01184352
Views:
57
I am appending records in a VFP table to the corresponding SQL table using a remote view. About 1/4 of them append properly. The remainder generate an error indicating that conversion of character data to datetime has created an out-of-range datetime value. All 7 of the SQL datetime fields correspond VFP date fields. Any ideas what am I missing here?
Next
Reply
Map
View

Click here to load this message in the networking platform