>Hi everyone,
>
>Just now I got this error message. I know why it happened, it's because I choose lot's of items in multilist, which affect on Init method one of my other controls. I think, it's VFP limitation 255 char on the macro string. So, my questions are:
>1) Will in VFP7.0 this limitation be fixed?
>2) How can I resolve this situation? Do I need to calculate length of my macro string, finding space, etc. Would be a real PITA :(
Don't put the entire SQL into 1 string for macro expansion. Do something like:
select &cFieldList ;
from table1 join table2 on table1.pk = table2.pk ;
where table1.fieldx in ('val1', 'val2') ;
and table2.fieldy &cFilter1 ;
group by &cGroupBy ;
order by &cOrderBy ;
into cursor MyCursor nofilter
Mark McCasland
Midlothian, TX USA