>Hi all,
>
>When i run this command i don't have error
>
>

>SELECT 'P1' AS cPauseNo , ;
>      cBk.* FROM NomPauseMois ;
>      INNER JOIN ColorBackPauseMois cBk ON cBk.iemplId = NomPauseMois.iemplId;
>      WHERE '/1' $ NomPauseMois.iemplId ;
>      UNION;
>      SELECT 'P2' AS cPauseNo ,;
>      cBk.* FROM NomPauseMois ;
>      INNER JOIN ColorBackPauseMois cBk ON cBk.iemplId = NomPauseMois.iemplId;
>      WHERE '/2' $ NomPauseMois.iemplId ;
>      INTO CURSOR TotPauseLettre READWRITE
>
> *--UT 05/2005 Fabio Le tour est joué on transforme '1458/1' ou '1458/2' en 1458(entier)
>*-- No error here
>    ALTER TABLE TotPauseLettre ALTER iemplId I
>

>
>This command give me strange error 1115 Invalid operation for the cursor.
>Field iemplId I exist !? I add only NomPauseMois.* in the two menbers of sql code.?
>

>SELECT 'P1' AS cPauseNo , ;
>      cBk.* ,;
>      NomPauseMois.* FROM NomPauseMois ;
>      INNER JOIN ColorBackPauseMois cBk ON cBk.iemplId = NomPauseMois.iemplId;
>      WHERE '/1' $ NomPauseMois.iemplId ;
>      UNION;
>      SELECT 'P2' AS cPauseNo ,;
>      cBk.* ,;
>      NomPauseMois.* FROM NomPauseMois ;
>      INNER JOIN ColorBackPauseMois cBk ON cBk.iemplId = NomPauseMois.iemplId;
>      WHERE '/2' $ NomPauseMois.iemplId ;
>      INTO CURSOR TotPauseLettre READWRITE
>
> *--UT 05/2005 Fabio Le tour est joué on transforme '1458/1' ou '1458/2' en 1458(entier)
>*-- Here I have now a 1115 error ?  iemplId I exist ( Number of field < 254 )
>    ALTER TABLE TotPauseLettre ALTER iemplId I
>

Your cursor (TotPauseLettre) contains a field with a name which is longer than 10 chars