Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Passing SQL-INSERT via ADO is producing incorrect dates
Message
From
29/05/2003 11:03:39
Kevin Lawrence
Cornwall Council
United Kingdom
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Object Oriented Programming
Title:
Passing SQL-INSERT via ADO is producing incorrect dates
Miscellaneous
Thread ID:
00793950
Message ID:
00793950
Views:
41
Hi

When I pass an INSERT-SQL like "INSERT INTO Table (DateField) VALUES ({15/01/2003})" via ADO Connection, VFP always places the date into the table as an American style format.

I have SET DATE TO British set via the DBC OpenData event, what else can I do?

Thanks
Kev
Next
Reply
Map
View

Click here to load this message in the networking platform