What I want to do is select records from a table based on the qqfield. The qqfield values for each record are different and are based on other variables in my program. So I can't just set a variable because the variable needs is different for each record. I tried the the double dot approach and it didn't work either. Do you have any other suggestions? The code with the change is below.
select * from promolist;
where qq_promo and BITTEST(region,0);
and DATE() <= promolist.expire;
and IIF(!EMPTY(promolist.qqfield),IIF(&Promolist..qqfield,.T.,.F.),.T.)
Thanks
Jim