Class objects and Memory

[Jarryd]

Hi,

I have heard that is a good idea to set recordsets = nothing. Is there a
way to do the same for class objects. or is there no point?

TIA,

Jarryd

 

[Guest]

You can set any object variable to nothing.

 

[Jarryd]

Then why do I get the following error message:

"Compile error:

Object required"
The objects I am setting to Nothing have all been initialised, and are
either Double or String. So what could be the problem?

TIA,

Jarryd

 

[John Spencer]

Could you post a sample of the code that is failing? I suspect that you are
trying to set a variable to nothing that is not pointing to an object.

Usually you will see the word SET when you are working with an object

SET MyRecordsSetVariable = ...

 

[RoyVidar]

Then why do I get the following error message:

"Compile error:

Object required"
The objects I am setting to Nothing have all been initialised, and are either
Double or String. So what could be the problem?

TIA,

Jarryd

In VB, that's data types (Date, String, Double, Integer...), and you
don't release variables declared as such.

Objects are instantiated using the Set statement

dim myobject as myclass
Set myobject = new myclass
' do something with the object
set myobject = nothing

- also, if the object is opened (like recordsets, connections ...),
one might close them first

And only those can be released - and many developers recommends to do
so.

 

[Jarryd]

Hi guys,

Put this one down to my own ingorance of basic terminology and programming
concepts. I had infact only declared variables of a certain datatype. E.g.:

Dim test as String
test = Form1_controlbox1

So if there is no need to release those then I'll just leave them as is.

TFYH,

Jarryd

"RoyVidar" <roy_vidar