Hi All,

I found the problem. I was first creating temp tables containing the correct structures. The problem was these were free tables and as such always truncated long file names.

I fixed the problem by first creating a temp.dbc and making all the temp tables members of the .dbc.

Thanks for the help.

regards
Doug Johnston


>Hi,
>
>I have a .dbc that I wish to programatically add new fields. I open the .dbc exclusively, the open the table I want to alter exclusively and then...
>
> ALTER TABLE (lcOldFile) ;
> ADD COLUMN &mfield c(mwidth)
>
>...however if the field name is greater than 10 characters, then the field name is truncated to 10 characters.
>
>Is there any way programatically to use greater than 10 chr field names.
>
>
>Regards
>Doug Johnston