wcboyd
Registered User.
- Local time
- Today, 17:50
- Joined
- Aug 30, 2004
- Messages
- 50
Hello All,
I am doing a lot of temporary queries like this:
I am deleting them w/n the same block of code when I am done with them.
Sometimes the queries overlap so I have taken to appending a number on the end. Thus, qryTemp01, 02, 03, etc..
I am using these for pass-through queries as they perform much better than the ODBC connection to my Oracle DB.
Is this the best way to do this or is there another way that is better?
I am doing a lot of temporary queries like this:
Code:
Set PTQuery = db_Oracle.CreateQueryDef("qryTemp")
Code:
CurrentDb.QueryDefs.Delete "qryTemp"Sometimes the queries overlap so I have taken to appending a number on the end. Thus, qryTemp01, 02, 03, etc..
I am using these for pass-through queries as they perform much better than the ODBC connection to my Oracle DB.
Is this the best way to do this or is there another way that is better?
