"Destroying a Dynaset"

[tigreeuropeo]

How do you "destroy" a Dynaset after creating it?
I want to reuse the dynaset variable, and I don't want to have garbage in this variable at the time of re-creating it.
Thanks in advance

 

[softwarescience]

Hello

In both ADO and DAO you need to close the dynaset object then you need to set it to nothing i.e.
dynaset.close
set dynaset = nothing

This will then allow you to use the variable again.

Hope this helps