>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 >>
>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 >