>>>I NEVER created myself table field, having name longer then 10 characters.
>>>
>>>alter table alias() works like charm for me in VFP6 :)
>>
>>What alias() returns? AFAIK this code should work just fine, but we're not using it in our code.
>
>alias() itself returns currently selected alias.
>
>In this case I was using this construction to alter cursor created by
>create cursor command as copy of actual table and then adding fields to it.
>
>something like
>
>
>select clients
>local arrStru(1)
>=afields(arrStru)
>create cursor rClients from array arrStru
>alter table alias() add column CustTot n(12,2)
>alter table alias() add column lastPur D(8)
>.
>
Is Clients table part of the database? Does it have some specific features of a table belonging to a database, such as PK, for example?
Also you may want to do ALTER TABLE as one step. It should be quicker.
>
>But unfortunately this construct does not work anymore in VFP9
If it's not broken, fix it until it is.
My Blog