Bonjour gregory,

ok i understan now !

when 2 same fields => Name Field = Name Field + '_a' = > LEN > 10 !

Thanks !



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