On 9/12/07, Jon Westcot <[EMAIL PROTECTED]> wrote: > 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?
I just hacked together a simple sample in VFP9 and it seems to work fine here. -- Paul _______________________________________________ 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.
