> #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 That should work fine. It sounds like your #DEFINEs aren't been seen, somehow. Just as a test, trying moving the #DEFINE to right before the Select statement, and try it. If it works there, then you have some sort of scoping issue.
_______________________________________________ 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.
