Re: VFP 9: #define constants

Gene,

VFP will perform substitution inside [] string delimiters

#define SUPERLATIVE better
sentence = [Father knows SUPERLATIVE.]
? sentence

-- 
--sb--

VFP MVP

Gene Wirchenko wrote:
>      I know that VFP will not perform substitutions within a string as
> in
>           #define SUPERLATIVE better
>           sentence="Father knows SUPERLATIVE."
> but is there a way to get a similar effect?
> 
>      I use SQLSEL as in
>           #define SQLSEL select
>           ...
>           SQLSEL clcode,clname from ccli order by clcode
> to differentiate between xBASE select statements and SQL select
> statements.
> 
>      Occasionally, I need to build an SQL statement with a subquery in
> it and would like to build the expression as in
>          wherecond=;
>           "&limitexpr and "+;
>           "trnnbr in (SQLSEL wonbr from cwko where woccode=currwocc)"
> This does not work.  I have to use "select" and make a note (so that
> when I search for SQL select statements, I can find them all.
> 
>      Any ideas?
> 
> Sincerely,
> 
> Gene Wirchenko
> 
> Computerese Irregular Verb Conjugation:
>      I have preferences.
>      You have biases.
>      He/She has prejudices.