>Thank,
>
>it 's not possible with a cursor ?
Try to use READWRITE NOFILTER clause in SELECT statement.
>
> 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
>
>
>
>>>>use
>>>>alter table tablename alter column fieldname i
>>>
>>>
>>>Thank Deepak,
>>>Thank jos,
>>>
>>>
>>>ALTER TABLE Temp ALTER [COLUMN] myfield I
>>>
>>>Give a syntaxe error....?
>>
>>Use
>>
>>
>>ALTER TABLE YourTableName ALTER myfield I
>>