>Does anyone know of a listing of what controls are bindable to ADO recordsets, and the proper syntax. I know grids are not, and the MSDATA Grid is working just ducky. Using the FOXCOM.dll method rsToCursor() to convert to Recordsets to Fox cursors is SLOOOOOW, it took 12 seconds to convert a recordset of 3000 records, on my Pentium 933 with 256 megs of RAM connected to SQL Server 2000, when the query of 500,000 took less than 1 second. The FOXCOM conversion is slowing the down the whole UI, I can't blame SQL server for this one. I'd like to bind all controls, listboxes, combos, checkboxes directly to ADO. Microsoft in usual fashion has nothing, I've tried Wiki, VFUG, nothing.

John,

I've been tinkering with another method of converting an RS to a cursor and tested it against VFPCOM.DLL. Although in my tests VFPCOM is faster 12 secs for 3000 rows is too much. How many fields does your RS has?

I will be posting this routine to the UT files this weekend and should be available sometime next week. If you would like to test it with your RS and check if it runs faster (according to my tests it should do much better than 12 secs for 3000 rows, depending on the number and type of the fields) I will be happy to email it to you tonight or tomorrow.