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.
ramil
~~ learning to stand still