Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO & SQL Server - Demo Code
Message
 
 
To
05/03/2010 06:56:02
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01452736
Message ID:
01452738
Views:
67
255/254 field limit apply as long as you want a cursor.

>
>Does anyone have some example code of using ADO to connect to SQL Server 2005 - I'm in a rush to complete some code (are we always), so something concise with example code would be brilliant.
>
>In essense, I want to retrieve a cursor from SQL Server 2005 (using a stored procedure within SQL Server), and then have a fully updatable cursor that's controlled by SQL Server 2005 but viewable/modifiable within VFP. I need to get to this point fairly quickly, hence asking for demo code by someone that's already done it and can easily demonstrate how to get the data, set the buffering properties, then commit the changes from within VFP.
>
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform