Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Launch Active doc
Message
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00159142
Message ID:
00160786
Views:
26
>I want to know how to bind directly ADO recordset with VFP objects....

You can't.

You can bind single controls to an ADO object's values though, but lists
etc. won't work.

>>The ADO2VFP conversion is slow, but ADO itself is very fast. You can bind your form objects directly to the ADO recordset...except the grid. I haven't played with XML. That is an option. You might also look at Ken Levy's web site, www.classx.com. He is doing some vidoes on working with ADO, XML, and a number of other things.

Depends on how you look at it. ADO itself is reasonably fast for
data access, but dog slow for ADO property access and retrieval of
data *values*, because it happens all over COM. Do a test sometime
in VFP or even compare VB and VFP code that does a SQL statement
and then a DO WHILE loop to go through all of the records to
retrieve and build a string from the data. Depending on size of
the data I've found ADO to be up to 10 times slower than VFP
code - where the actual queries are only marginally slower (about
10-15% which would be attributable to the ODBC conversion overhead).

+++ 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