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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.