Closing stored procedure within loop

[mhenley]

I'm calling two stored procedures (get_three and get_five)that are each returning a record set. I'm calling the first one then starting a loop until eof, where I use data from the first recordset to call the second...


DE.Get_three
Do until DE.rsGet_three.eof
three_id = DE.rsGet_three(1)("three_id&quot
DE.Get_five three_id
Do until DE.rsGet_five.eof
'display data here...
DE.rsGet_five.movenext
loop
DE.rsGet_three.movenext
loop


Loop one executes fine (the internal loop completes until eof) but after the get_three loop executes once I get "The operation requested by the application is not allowed if the object is open" on the line containing the call to the get_five procedure. I'm guessing I need to close the object before I call the procedure again with different data but I can't figure out how. I have tried DE.get_five.close and DE.rsGet_five.cancel, but doesn't seem to have any effect.

Any help would be greatly appreciated!
Matt
[sig][/sig]

 

[mhenley]

FYI: I fixed this by closing the recordset (DE.rsGet_five.close )

DE.Get_three
Do until DE.rsGet_three.eof
three_id = DE.rsGet_three(1)("three_id&quot
DE.Get_five three_id
Do until DE.rsGet_five.eof
'display data here...
DE.rsGet_five.movenext
loop
DE.rsGet_Five.close
DE.rsGet_three.movenext
loop

[sig][/sig]