>Thanks Cindy... You are exactly right. I have quite a few that already work and some are really complex. I chose ADO because I want to be able to web enable many of my future apps. Perhaps ADO was not the best choice. I am relatively new to doing things this way. We have previously been just opening tables or using the DE.
>
>I wonder what most others use to build their data layer around?
>
>Seems that ado is probably the most flexible solution in the long run after finally getting things converted over.

VFPCOM RSToCursor() has a problem converting numeric data types, which makes it pretty useless IMO. Check out RS2DBF on the Code Samples page of the Visual FoxPro site. If you are returning large datasets, you'll notice a pretty hefty performance hit for the conversion. At least that's my experience with recent testing.