Re: & Removal in Expressions

Cy Welch <cywelch@[EMAIL PROTECTED]
> wrote:

[snip]

>How much data are you working with?  And how many queries?  I do find 

     The work transactions for a small services company, say ~10000
rows per month.

     It is for analysis re****ts.  I am building a cursor of the data
to be re****ted on.

>that it does seem to work better if I build the entire string then macro 
>substitute but it looks like that is what your doing.

     I have used both approaches.  I prefer to use macro substitution
where possible.  That way, I can still have the statement expressed
with my usual indentation style.  Most of my substitutions are where
expressions or parts of them or the tables/cursor.  e.g.
          select * from cwko;
          where wostatus="B" and &dateexp;
          into cursor (alwolist)
I can not remember a case where I have fiddled with column names.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
     I have preferences.
     You have biases.
     He/She has prejudices.