In the first example, I'm thinking it is because a new temporary table is created, the old one deleted, and it's a free table so it's limited to 10 characters? I have no idea why in the 2nd example, but it has been around for awhile and is a problem with the ALTER TABLE command.


>Hi All,
>

>*** this is the first bug *********
>CREATE CURSOR test (shortf c(1))
>
>ALTER table test add long_field_name c(1)
>
>***** this is the second bug *******
>CREATE CURSOR test (long_field_name c(1))
>
>ALTER table test add shortf c(1)
>