You are on the right track. You also need the following property filled in for the CursorAdapter:
oca.SelectCmd = "select * from vendors"
I am trying to get this to work as well, but even with the SelectCmd property filled in, I still get false for CursorFill. I'll let you know if I get it working.
>I checking out the new cursoradapter class but I can't get it to work
>
>oconn=createobject("adodb.connection")
>oconn.connectionstring="someodbcDSN"
>oconn.open()
>
>ocmd=createobject("adodb.command")
>ocmd.activeconnection=oconn
>ocmd.commandtype=1
>ocmd.commandtext="select * from vendors"
>
>ors=createobject("adodb.recordset")
>
>oca = createobject("cursoradapter")
>oca.datasourcetype="ADO"
>oca.datasource=ors
>oca.alias="test"
>
>? oca.cursorfill(.f.,.f.,1,ocmd) && returns false
>
>What I am doing wrong?
>
>Any help is greatly appreciated.
Mark McCasland
Midlothian, TX USA