regexp question

[ethorn10]

I have a question mainly at an idea than how to solve something. I am aware that when dealing with Connection and Recordset objects they need to be closed and set to nothing as a housecleaning practice. Does the same hold true for the RegExp object? Will it cause the same types of issues that Connection and Recordset objects cause if not closed and set to nothing?

Thanks

 

[onpnt]

Yes

___________________________________________________________________

_{onpnt.com
SELECT * FROM programmers WHERE clue > 0
(0 row(s) affected) -->faq333-3811}

 

[ethorn10]

well that didn't take long. thanks onpnt. is this the case with ALL objects? i assume it is.

 

[onpnt]

Absolutely. Reg objects only need be set = nothing as other objects that do not make connections and leave open lines to sources.

It is highly recommended that things of this nature (like reg objects) are created --> used --> closed at every instance it is needed. use functions/procedures to utilize the objects by passing and returning parameters to keep them under control and such.

Object usage can be a major factor on performance of your app's so you should use them knowingly and sparingly


___________________________________________________________________

_{onpnt.com
SELECT * FROM programmers WHERE clue > 0
(0 row(s) affected) -->faq333-3811}

 

[ethorn10]

ok. i didn't notice a .close method for the regexp object so it ONLY needs:

set re = nothing

(or whatever we call our instance of the object)