Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date fields on SQL-Server
Message
From
03/01/2001 17:05:47
George Simon
GS Data Technologies, LLC
Cincinnati, Ohio, United States
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00459116
Message ID:
00459126
Views:
23
Tom,

>I suppose I could possibly scan this second cursor for changes manually and create the SQL Updates in code, but that seems like it could be slow.

I chose this technique and performance is not an issue. I'm doing all of my updates with stored procs so scanning the update cursor was necessary anyway.

Also keep in mind that SQL Server does not have an empty {} value for datetime like VFP. So you have to look out for NULL datetime values.
George Simon, MCP
Previous
Reply
Map
View

Click here to load this message in the networking platform