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