Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Parameters queries
- Thread starter EvilCabal
- Start date
You could try using code to create an SQL String, which you then use to replace the SQL String for the query you want to run.
The benifits will be that all the parameters will become 'hardcoded' within the query, so it should run much faster. Next time you want to run that query again, you will change the SQL property again.
Its all done with querydefs. Whilst this might not be exactly what you want to do, but it might give you some ideas!! Check here: faq701-2328
Good Luck, and HTH
Mincefish
The benifits will be that all the parameters will become 'hardcoded' within the query, so it should run much faster. Next time you want to run that query again, you will change the SQL property again.
Its all done with querydefs. Whilst this might not be exactly what you want to do, but it might give you some ideas!! Check here: faq701-2328
Good Luck, and HTH
Mincefish
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question
