Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error converting date to SQL datetime
Message
From
10/01/2007 15:31:44
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01184352
Message ID:
01184359
Views:
17
>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?

Empty data perhaps?


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform