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