How can i DROP a QUERY

[nandamurisrihari]

how can i drop a query like droping a table using following code "dba.Execute "DROP TABLE " & TableNAME & ""

regards
srihari

 

[mp9]

You still use DROP TABLE, i.e. to drop a query called qryDel the SQL would be:

DROP TABLE qryDel;

I know it seems strange, that's just the way it is!

http://www22.brinkster.com/accessory/

 

[nandamurisrihari]

Hi,
we can use the following code for deleting a query
"dba.QueryDefs.Delete QueryName"

this will work
anyway thanks a lot for helping me out
cheers
srihari