>Hi Gregory.
>
>Ooops. Yes I can do this.
>I was shure to have tried and failed ages ago (VFP 5 ???). And I never use fieldnames longer then 10 chars.
>
>Lutz
>
>>>#4 A cursor structure can not be altered (The command is ALTER
TABLE)
>>
>>
>>Oh, yes, it can - as long as the length of the fieldname is max 10 chars - beyond 10 chars you will get an error
>>
>>> If you need to alter a structure, you would need SELECT .. INTO Table and later ALTER TABLE
>>
>>Not necessarily
>>
>>
>> create cursor tmp ;
>> ( Id I, ;
>> Name c(20);
>> )
>> insert into tmp values (1, '1')
>> insert into tmp values (1, '1')
>>
>> alter table tmp ;
>> alter Name c(10) ;
>> add FirstName c(15);
>>
>>
>>
Thanks, guys.