Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Launch Active doc
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Applications Internet
Divers
Thread ID:
00159142
Message ID:
00160786
Vues:
28
>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?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform