Try this:

SELECT IIF(ISNULL(FFTRACK.DESCRI_FR),FFFOLLOW.DESCR_FR,FFTRACK.DESCRI_FR) AS DESCR_FR,;
IIF(ISNULL(FFTRACK.ORDER_COMPLETED),"N",FFTRACK.ORDER_COMPLETED) AS ORDER_COMPLETED;
from fffollow;
LEFT OUTER JOIN fftrack on fffollow.ident = fftrack.ident_fffollow ;
WHERE FFTRACK.CONSOLID = THISFORM.consolid AND;
FFTRACK.IDFILE = thisform.fileid;
INTO CURSOR cur_fffollow READWRITE


>Je recois ce message d'erreur (too many arguments) lorsque que je veux sauvegarder le bout de code situer en bas. Si je m'es seulement un IIF cela marche autrement ca marque ce message.
>
>Merci !!!!
>
>P.S(Voila le code)
>
>SELECT (IIF(ISNULL(FFTRACK.DESCRI_FR),FFFOLLOW.DESCR_FR,FFTRACK.DESCRI_FR)) AS DESCR_FR,;
> (IIF(ISNULL(FFTRACK.ORDER_COMPLETED,"N",FFTRACK.ORDER_COMPLETED)) AS ORDER_COMPLETED;
> from fffollow;
>LEFT OUTER JOIN fftrack on fffollow.ident = fftrack.ident_fffollow ;
>WHERE FFTRACK.CONSOLID = THISFORM.consolid AND;
> FFTRACK.IDFILE = thisform.fileid;
>INTO CURSOR cur_fffollow READWRITE