Check for existing query

[Pamy]

Hi,

I need to run different SQL statement in the same query. And this is what i have coded.

Set db = DBEngine(0)(0)
strSQL = "Select * from XXX"
Set qdf = db.CreateQueryDef("QryApplicant", strSQL)

The code execute for the first time, but failed on the second attempts. I supposed because there is already existing query in the database. How can i overwrite the SQL statement without deleting the existing Query.

Thanks you and Merry X'Mas

 

[Darrylles]

Hiya,

You've tried:

strSQL = "Select * from YYY"
Set qdf = db.CreateQueryDef("QryApplicant", strSQL)

And it doesn't work?

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[Pamy]

Yap