Hi all:
I'm trying to generalize an application that I've been maintaining for
several years and have hit a bit of a brick wall. I've been trying to set
up a number of #DEFINE values that get loaded by the uppermost object in the
application that are then used throughout the rest of the application. This
approach has worked nicely except for one situation: I can't seem to make it
work when I issue a SELECT statement.
For example:
In an included header file:
#DEFINE TYPE_TOOL_SEQ 998
#DEFINE TYPE_FEES_SEQ 999
Then, later on, in a SELECT statement:
SELECT * FROM table WHERE rec_seq < TYPE_TOOL_SEQ
I get a run-time error telling me that the variable TYPE_TOOL_SEQ is not
defined. I thought that, under the covers, the compilation of the
application would convert the code into something like:
SELECT * FROM table WHERE rec_seq < 998
even though it would continue to appear as I typed it above.
Is there a way to make this work? Or do I need to do something somewhat
less appealing, like put these constants into an INI file or into the
Registry?
Thanks for any help you can send my way.
Jon
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
