SyntaxSocialist
Registered User.
- Local time
- Today, 05:00
- Joined
- Apr 18, 2013
- Messages
- 109
Noob question, probably, but some cursory searches failed to deliver what I'm sure is a pretty simple answer.
QueryDef objects (http://msdn.microsoft.com/en-us/library/office/bb177500(v=office.12).aspx) have a couple properties I'm having a hard time understanding the difference between:
What's the difference between a query definition and query parameters? I was under the impression that parameters are essentially the WHERE clause, and thus a part of the definition... but I'm starting to think I'm wrong on that one.
QueryDef objects (http://msdn.microsoft.com/en-us/library/office/bb177500(v=office.12).aspx) have a couple properties I'm having a hard time understanding the difference between:
- Use the SQL property to set or return the query definition.
- Use the QueryDef object's Parameters collection to set or return query parameters.
What's the difference between a query definition and query parameters? I was under the impression that parameters are essentially the WHERE clause, and thus a part of the definition... but I'm starting to think I'm wrong on that one.