You are right! But why I am thinking I use it? I just checked & find out You are right (I am not so happy of that :o)))))
>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.