Temp.Table results from Stored Procedure into rs
I was wondering if any of you out there can help me out please...
I have a stored procedure which comprises of a UNION of two SELECT statements
storing the results into a temporary table (#Table)...
Using ADO I call the stored procedure passing the results into into a recordset.
Until now using normal SELECT statements in my Stored procedures I've had
no problems. Using the more involved SELECT/Temp table use, Ive struck a
problem. I now get the message
"Operation is not allowed when object is closed"
Now I've tested the exact code switching the Stored Procedure name with
a stored procedure used previously and it works fine. I went back to the
problem stored procedure and removed the line :
DROP Table #Table ..thinking its dropped the results before sending it to
the recordset...to no avail..
My VB referring to the stored procedure call is as follows :
adoCommand.CommandText = "StoredProcedure"
adoCommand.Commandtype = adCmdStoredProc
adoCommand.Name = "MultipleResults"
Set adoCommand.ActiveConnection = adoGlobalConn
do while not rstglobal.eof <----- error Above given here
(My record set is Static, LockBatchOptimistic....)
Any assistance would be much appreciated.
Many Thanks in Advance,
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center