Hi Serg,

if you use Readwrite, you don't have to use Nofilter.

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