Deleteing dbs objects.

[Guest_imported]

Hello,

I have defined an sql statement, to automatically create a
querydef called dummy, as below :-

Set qdf = dbs.CreateQueryDef("dummy", strSQL)

This works great the first time, but upon second go, as the object has already been created, I get "object already exists" message.

I have tried to do this earlier in the code

Set qdf = dbs.QueryDefs.Delete("dummy&quot

which just stops the code working altogether.

Is there another way of deleting, or overwriting the object.

thanks

 

[link9]

set object = nothing

 

[MichaelRed]

Setting to nothing removes the reference to the object, NOT the object. A way is to create the dummy querydef as most any thing, thte after instantiating it via:

Set qdf = dbs.QueryDefs("dummy&quot

Set it's SQL PROPERTY

qdf.Sql = strSQL

Another way is to create an UNNAMMED query def:

Set qdf = dbs.CreateQueryDef(, strSQL)


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over