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