
Question Ado 2.7 Field Object , Vb6.0
Does anyone know if there is cleanup involved with the adodb.field
object?
I have a VB 6.0 app that loads a recordset and returns the field
info.
Here is a snipet using a fake SQL statement
------------
Dim rs as adodb.recordset
dim fs as adodb.field
Set rs = new adodb.recordset
rs.open "Select Music_Score,Grade From FakeTable",Cn,3,4
Set fs = rs.fields("Music_Score")
txtfake.text = cstr(fs.actualsize)
rs.close
set rs = nothing
set fs = nothing
---------------
This is the basics, but it's leaking after each call of this sub. The
app gains in memory usage. Do I have to close the field object?
If I remove the field object and call directly from the recordset, the
leak goes away, so I think it's pretty much narrowed down to the field.
I am currently skipping the whole field object stuff and going directly
to the fields collection of the recordset as a workaround, but I'd like
to know if I missed a step
Thanx
DRC
Alphabet collector (MCP,MCSD,MCSA,NECD ECT.)
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!