Thank fabio !

>>Hi all,
>>
>>How can i place a condition in code text endtext ?
>>
>>

>> nOrdre = 1
>>
>>  TEXT TO lcSql NOSHOW TEXTMERGE
>>  SELECT  LEFT( T.cnomteleph , 20 )  + ' - F.' + TRANSFORM( Ve.cnofact , "99999999" ) AS 'cName',;
>>    Ve.iid;
>>    FROM amline!cfiltre cf INNER JOIN amline!Vente Ve ON Ve.iid = cf.itelephoneid ;
>>    INNER JOIN amline!Teleph T ON  Ve.itelephoneid = T.iid ;
>>    INNER JOIN amline!Resident R ON  T.iid = R.itelephoneid ;
>>    IF nOrdre= 1
>>     ORDER BY 1 DESC INTO CURSOR cNames
>>    ELSE
>>     ORDER BY 1 INTO CURSOR cNames
>>    ENDIF
>>  ENDTEXT
>>
>>

>>
>>bernhart
>
>

>nOrdre = 1
>  TEXT TO lcSql NOSHOW TEXTMERGE
>  SELECT  LEFT( T.cnomteleph , 20 )  + ' - F.' + TRANSFORM( Ve.cnofact , "99999999" ) AS 'cName',;
>    Ve.iid;
>    FROM amline!cfiltre cf INNER JOIN amline!Vente Ve ON Ve.iid = cf.itelephoneid ;
>    INNER JOIN amline!Teleph T ON  Ve.itelephoneid = T.iid ;
>    INNER JOIN amline!Resident R ON  T.iid = R.itelephoneid ;
>    <<IIF(nOrdre= 1 , [ORDER BY 1 DESC INTO CURSOR cNames] , [ORDER BY 1 INTO CURSOR cNames])>>
>  ENDTEXT
>DEBUGOUT lcSql
>

><<>> don't support command line splitter ";"