>I have alot of fields of the same type and I need to set filt to for each one of them simultaneously. Example: set filt to state1="paid" .or. state2="paid" .or. state3="paid" .or. state4="paid".......state30 ="paid" etc down to over 30 states.
>
>How can I get around this limitation?
I use the following procedure:
proc SETFILT
para prmFILTER
priv i, m
for m.i=1 to 8 && 8 == 2048/250 -1
m='M'+ltri(str(m.i))
priv &M
&M = subs( m.prmFILTER, (m.i-1)*250+1, 250 )
endfor
set filter to &m1&m2&m3&m4&m5&m6&m7&m7&m8
return
Andrus