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