>>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?
>
>SET FILTER TO INLIST("paid", state1, state2, ...state19) ;
> OR INLIST("paid", state20, state21, ...state30)
>
>You need multiple INLISTS because the limit is 24.
So you'd need to copy the result of the first statement to another dbf and perform the next 'inlist' upon that?
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."