I
inungh
I just wanted to make my app clean, because there are too many queries
stored on the mdb file.
I tried to stored my SQL in my table like tblSQLstring and retrieve
them to use currentDB.execute strMYSQL, dbFailOnError
It works fine,
The only thing is when I need run more than one query to get my result
set.
I need run second query against the first recordset.
I tried to use querydef.SQL and use mydb.execute strMYSQL.
Are there any better solution for this method?
Your help is great appreciated,
stored on the mdb file.
I tried to stored my SQL in my table like tblSQLstring and retrieve
them to use currentDB.execute strMYSQL, dbFailOnError
It works fine,
The only thing is when I need run more than one query to get my result
set.
I need run second query against the first recordset.
I tried to use querydef.SQL and use mydb.execute strMYSQL.
Are there any better solution for this method?
Your help is great appreciated,