OIC. What kind of error message are you getting? Do you really need to use a CA for this?

>Hi Mark,
>
>Thank you for the prompt reply. I've already downloaded your CA builder a while back. However, I need to create these views on the fly and on the backend or datasource.
>
>I was hoping to be able to use the Ado Command object in conjuctions with the cursoradapter.
>
>My problem is that, I can run this codes from the command line without problem on my local machine but will break on any other machine. I created a virtual Pc and got the same error. Convert back the expanded ADO names.
>
>

>Assuming: database: DATA2.DBC exists with a table called WH.DBF (WID i, WNAME C(10))
>oConn = createobj('AdoDb.Connection')
>oConn.ConnectionString = "Provider=VFPOLEDB.1;Data Source=data2.dbc;Password='';Collating Sequence=MACHINE;"
>oConn.Open()
>
>oCmd = createobj('AdoDb.Command')
>oCmd.ActiveConnection = oConn
>oCmd.CommandText = "create view vw_wh as select wid,wname from wh"
>oCmd.Execute()
>

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