Results 1 to 2 of 2
2001-11-05, 08:33 #1
- Join Date
- Feb 2001
- Thanked 1 Time in 1 Post
converting intrinsic constants (2000 SR1a)
This is similar to a recent thread, and I fear the answer may be the same, but I'm feeling worn out and lazy so I thought it might be worth a try.
Is there any easy way to look up the name of an intrinsic constant? For instance, I want to loop through all the possible values of the querytype parameter in the OpenSchema method of an ado connection (passing the querytype value as a number - the counter), then save the resulting file with filename databasenamequerytypeparametervalue, where the parameter value appears as the name of the intrinsic constant, not its numeric value (I really don't want to have to remember that 23 is the value of adSchemaViews, for instance).
Sure I can look them all up, make a table etc, but given the fact that I'm saving the file in the first place rather than going to the effort of writing the code to make a table from the recordset, that doesn't fit with my current indolent state.
Yeah, yeah, lazy folk work the hardest, I know. But please, if you have any suggestions, indulge me.
2001-11-05, 13:44 #2
- Join Date
- Jun 2001
- Crystal Beach, FL, Florida, USA
- Thanked 36 Times in 35 Posts
Re: converting intrinsic constants (2000 SR1a)
I don't think so. Remember, intrinsic constants when used in your VBA code are converted at compile time to their numeric equivalent. This is why, for example, you can use an intrinsic constant in your code, but not in a saved query.