When you set filter your way, locac variable lcfilter disappeares as soon as you quit the subrutine where it was declared. But the table remains with /set filter/ having lcfilter in filter expression.

When you use local variable lccom, then filter expression contains real values instead of variable lcfilter. And as soon as macro executed (&lccom) and filter is set, variable lccom is not needed anymore.


>This worked! Thanks. But why does it work? lccom is a LOCAL var just like lcfilter.
>
>Thanks,
>
>Jerryt
>
>
>>local lccom
>>lccom="SET FILTER TO mytable.myfield = '+lcfilter +"'"
>>&lccom