Re: [Tcl-tdbc] $resultset close

[Patrick D. <pat...@ac...>]

Are there any resources wasted if I do the following:

set sql "update mytable set column1 = 'ABC123'"
set result [[$conn prepare $sql] execute]


and don't call $result close?

In other words, for update / insert / etc. statements do we have to call
$results close. 

Presently I am only calling $results close on select statements. However
some of these processes run for days, even weeks or months on end so I don't
want to cause a memory leak or whatever. 

Thanks,


Patrick Dunnigan

Email: pat...@ac...

Visit us at www.activecompliance.com

This e-mail message is intended only for the use of the individual or entity
to which it is addressed, and may contain information that is confidential.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have received
this communication in error, please notify us immediately by reply email.


-----Original Message-----
From: Kevin Kenny [mailto:kk...@ny...] 
Sent: Wednesday, February 18, 2009 12:39 AM
To: pat...@ac...
Cc: tcl...@li...
Subject: Re: [Tcl-tdbc] $resultset close

Yes, it's required.  You can have as many prepared statements per
connection as you please, and as many result sets per statement as
you please.  Close them when you're done with them.

-- 
73 de ke9tv/2, Kevin