>Dear Moore,
>
>Thank you for your reply! I try to write a program to return a recordset from DLL using ADO but it doesn't work. Could you show me how can I do that?
>
>My sample program :
>
>-Create a new custom object(named as "DBTEST") within a visual class(named as "testdll") and add a new method named as "listdata"
>
>-Command on "listdata" as below
>
>cn = createobject('ADODB.Connection')
>rs = createobject('ADODB.RecordSet')
>
>cn.open("TESTDB")
>rs.open("Select * from testdb",cn)
>
>Return rs
>
>- Build DLL file and register it.
>
>-Command on the program TEST.PRG to call DLL
>
>x = createobject('testdll.dbtest')
>y = x.listdata()
>
>After run the program, type of variable y is UNKNOWN TYPE. Could you tell me what's the problem. Thank you for your help!!
>
>Best Regards,
>
>Justy Chow
Did you verify that your ADO connection and query are succeeding? What you are trying should work, I do it all the time.
Erik Moore
Clientelligence