>Hi all,
>
>How do I create a persistent view in the datasource using ADO with CursorAdapter?

You mean like a CA class that you can just add to the DE of a form without having to use the builder every time? If so, get my CABuilder and run it against your database. It will create a class lib with a CA class for every table in your DB whether it is a DBC, SQL Server DB, or Oracle schema. Just read all the comments near the top of the CABuilder PRG file.

Click on the FoxPro Tools link at http://www.mctweedle.com to download. It is totally free. I will be posting a new builder for VFP9 soon.