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