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 IThis command give me strange error 1115 Invalid operation for the cursor.
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