Try putting your SQL statement into a variable first.

lcSQL = 'SELECT rub_code,rub_libelle,rub_alias,;
 rub_touche,trub_libelle,rub_etat,;
 ser_code,trub_code FROM Rubrique Rubrique INNER JOIN Typerubrique Typerubrique;
 ON Rubrique.trub_code=Typerubrique.trub_code;
 WHERE ser_code=?Cser and SUBSTR(rub_libelle,1,3) NOT IN("acc","ind")','Cursdetail')'
SQLEXEC(gnConnHandle,lcSQL)

>HI ALL ,
>
>here the error message 'Command contains unrecognized phrase/keyword' . I thing my select is too long . what can I do ?
>
>
>

> SQLEXEC(gnConnHandle,'SELECT rub_code,rub_libelle,rub_alias,;
> rub_touche,trub_libelle,rub_etat,;
> ser_code,trub_code FROM Rubrique Rubrique INNER JOIN Typerubrique Typerubrique;
> ON Rubrique.trub_code=Typerubrique.trub_code;
> WHERE ser_code=?Cser and SUBSTR(rub_libelle,1,3) NOT IN("acc","ind")','Cursdetail')
>

>
>Best regards