Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO, CURSORADAPATER and Parameters
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00973221
Message ID:
00973464
Views:
16
Hi Aleksey.


>You have to pass ADODB.Command object to the CursorFill method.
>
>loCommand = CREATEOBJECT("AdoDb.Command")
>loCommand.ActiveConnection = oConn
>? ca.CursorFill(,,,loCommand)
>
YEah I eventually got that to work last night after a bunch of back and forth <g>. I haven't been using the CA much for anything and it's tough finding documentation on nuances like this... I had to dig into an MSDN article to find this on a somewhat unrelated topic and all of a sudden it started working once the command object was passed.

BTW, I want to thank you for your help a few weeks back. That snippet of code was very helpful in figuring out the Unicode stuff I'm working on at the moment. I'm updating some existing libraries to retrofit for ADO usage in addition to SQL Passthrough and I have most of it working without making changes to the codebase of an that this needs to plug into.

+++ Rick ---
+++ Rick ---

West Wind Technologies
Maui, Hawaii

west-wind.com/
West Wind Message Board
Rick's Web Log
Markdown Monster
---
Making waves on the Web

Where do you want to surf today?
Previous
Reply
Map
View

Click here to load this message in the networking platform