You can use ALTER TABLE on cursor under 2 conditions:
1. The cursor has to be created with write access
2. The cursor shouldn't have field names longer than 10 characters.
>
>it 's not possible with a cursor ?
>
> SELECT 'P1' AS 'cPauseNo' , NomPauseMois.* FROM NomPauseMois WHERE ;
> '/1' $ NomPauseMois.iemplId && NomP1.COUNT > 0;
> UNION;
> SELECT 'P2' AS 'cPauseNo' , NomPauseMois.* FROM NomPauseMois WHERE;
> '/2' $ NomPauseMois.iemplId INTO CURSOR TotPauseLettre
>
> *-- UT 05/2005 Le tour est joué , on transforme '1458/1' ou '1458/2' en 1458 ( entier )
> ALTER TABLE TotPauseLettre ALTER iemplId I
>
>
--sb--