|
-
Aug 25th, 2000, 01:13 AM
#1
Thread Starter
Lively Member
Can I return a Recordset from a DLL called by my EXE?
My DLL does all DB access and I would like to return an actual recordset in some cases to easily populate a grid with the RS information.
I get an error when I do as follows:
*****************************************************
Command_Click
*****************************************************
Dim objCase As LBCom2.Case
Set objCase = CreateObject("LBCom2.Case")
Dim objRS As ADODB.Recordset
Set objRS = CreateObject("ADODB.Recordset")
objRS.ActiveConnection = Nothing
Set objRS = objCase.GetCases
Do While Not objRS.EOF
..... Grid Code Here
Loop
*****************************************************
The GetCases Function Returns a Recordset, but I get and error trying to access the RS within the EXE.
Error 3704-Operation not allowed when the object is closed.
I don't have a connection to open it with....
What can I do???
Thanks!
Kevin
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|