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