You've to use macro substitutuon in this case
SELECT Traiter.cpauseid1 , Traiter.cpauseid2 FROM Traiter ;
ORDER BY &cGroup ;
INTO CURSOR Temp
>Hi all,
>
>I want to put variable in the clause group of a Sql. request.
>
>LOCAL cGroup
>cGroup = "Traiter.cpauseid1"
>
>SELECT Traiter.cpauseid1 , Traiter.cpauseid2 FROM Traiter ;
> ORDER BY ( cGroup ) ;
> INTO CURSOR Temp
>
>Give a error.
>sql column 'cgroup' is not found.
>
>
>Who can give me good syntax?
>
>thank you thousand times In advance
>
>bernhart
--sb--