Information générale
Catégorie:
Codage, syntaxe et commandes
Hi Mike.
When I do a select statement w/o “into table” the filed names remain as they are, but as soon as I add the “into table” option, it truncates the field names to 10 characters.
As Cetin already told you, freee tables do not support l;ong field names and that is what you create when you SELECT ... INTO TABLE.
Is there some reson that you need the results of the SELECT to be persistent? If not, why don't you SELECT INTO CURSOR? The using a cursor instead of a table will preserve your long field names and have the advantage of allowing you to get rid of the cursor when you are finished with it < s >.
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