Since this is an executable statement, not a value, you can't use EVALUATE() here. You must use a macro (&) for an executable statement.


>Suhas As Matin said use &abc, Never use m. when You try to evaluate a macro, the macro stops to the first point in Your case You try to evaluate &m and that is because You get an error message. You can use EVALUATE(m.abc) instead.
>
>>hi all,
>>
>>this select exectues fine
>>
>>select dist f1 from foo where f2 > 10 into cursor testfoo
>>
>>but this fails
>>
>>m.abc = "select dist f1 from foo where f2 > 10 into cursor testfoo"
>>&m.abc
>>
>>
>>how to solve it ?
>>
>>
>>TIA
>>
>>suhashegde