>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)She can use TEXT TO and she can also make it shorter (although it is not too long in this example):
lcSQL = 'SELECT rub_code,rub_libelle,rub_alias,;
rub_touche,trub_libelle,rub_etat,;
ser_code,trub_code FROM Rubrique RU INNER JOIN Typerubrique TR;
ON RU.trub_code=TR.trub_code;
WHERE ser_code=?Cser and SUBSTR(rub_libelle,1,3) NOT IN("acc","ind")','Cursdetail')'
SQLEXEC(gnConnHandle,lcSQL)
