Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADOGetRows.jcRStoCursor conversion (ADO-VFP)
Message
From
05/06/2001 10:13:56
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
ADOGetRows.jcRStoCursor conversion (ADO-VFP)
Miscellaneous
Thread ID:
00515082
Message ID:
00515082
Views:
65
All,

I've submitted an ADO rs to VFP cursor conversion class to the downloads section that is based on the code available from MSKB Q192692 (Ken Levy's code). The idea was to build a fast conversion program and while it does run faster than rs2dbf.prg VFPCOM still does a better job at it. But, it's another source-code alternative to VFPCOM and other options out there.

Hope you like it!

(Leame.txt en Español)

Contents of the readme file follows:
------------------------------------
STORY
This is an ADO recordset to VFP cursor conversion class. The conversion is based on ADO's GetRows() method that basically returns an array with data. Back when I started to concoct this I thought that it may run faster than the original rs2dbf because of the arrays. My first tests even hinted that it was performing better than VFPCOM but when I finished the complete routine and all was said and done VFPCOM's rstocursor is still faster that this approach.

Right now with everything going to XML and VFP7 having its own routines for this it's probably kind of late in the game for such a utility. But hopefully people will still find it useful, especially in cases where it can be compiled with a COM EXE or DLL.

DATA TYPE SUPPORT
It does not support binary fields, but it does handle numeric, character and memo fields OK for VFP, Access and SQL Server data sources. I did not test it with any other data source.
------------------------------------

Feel free to contact me with your comments.
Reply
Map
View

Click here to load this message in the networking platform