Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement