Hi all, I've had a problem for a while with data sessions that won't close, no tables(cursors) remain open, and there are no dangling object references as far as I can tell, I released every variable manually, display memory shows "0 variables defined", but the data session remains open. I've also used David Frankenbauch's (hope I got that right) ObjRef utility to check on this.
I've managed to pin it down to this single line of code
lnRV = loRS.Fields(1).Value
loRS is an ADO recordset returned from an ADO Command object, I can't see the problem with this value asignment, I'm not creating a reference or anything.
This code is in a method in my base form class, lnRV is declared as a local variable and is the return value for the method. If I comment out the line the data session closes normally, if I leave it as it is the data session remains open as Unknown(somedatassesion id).
I don't know if this causes any problems, I'm worried about a possible memory leak though. TIA for any help.