I realize that the DBCT is nearing its 20th birthday, and probably is not a priority for a fix, but this is so simple and has tripped up a number of LabVIEW programmers doing database applications for so many years.
The VI Rec Fetch Next Recordset (R).vi has a flaw which manifests itself in stepping past the last recordset in a multi-recordset return - then leaks a reference which causes mayhem in downstream code. A simple test of the recordset reference would make this VI properly useful.
Among my other posts in reply to forum users about databases, the issue is captured succinctly here.
I long ago made the mods to the toolkit VI (actually, two), and reapply them with each new LabVIEW version as needed. If anyone at NI/Emerson wants to look into this, I'd be happy to share the particulars.
Dave
David Boyd
Sr. Test Engineer
Abbott Labs
(lapsed) Certified LabVIEW Developer
