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);
>
>
>
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]