Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DISPLAY Field Name Truncation Problem
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
DISPLAY Field Name Truncation Problem
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01173226
Message ID:
01173226
Vues:
51
Hello Gurus!!

For the first time, I've run into this problem!!! Guess I never used LONG field names before!!??!!

When using the DISPLAY STRUCTURE command on a table with LONG field names, I get this output....
Structure for table:                   C:\PHARMACY\TABLES\DRUG.DBF
Number of data records:       191274  
Date of last update:          11/28/06
Memo file block size:         64
 Code Page:                   1252
                Field        Field Name                                                            Type                                                                                                   Width                           Dec                   Index   Collate                                            Nulls                               Next                               Step
                    1        DRUG_ID                                                               Integer                                                                                                    4                                                   Asc   Machine                                               No
                    2        NDC                                                                   Character                                                                                                 11                                                                                                               No
                    3        ACTIVE                                                                Logical                                                                                                    1                                                                                                               No
                    4        NAME                                                                  Character                                                                                                 25                                                                                                               No
                    5        FORM                                                                  Character                                                                                                  3                                                                                                               No
                    6        STRENGTH                                                              Character                                                                                                  8                                                                                                               No
                    7        SIZE                                                                  Numeric                                                                                                    8                             3                                                                                 No
                    8        DEA_CLASS                                                             Character                                                                                                  1                                                                                                               No
                    9        THIRD_PARTY_..                                                        Character                                                                                                  1                                                                                                               No
                   10        MANUFACTURER                                                          Character                                                                                                 30                                                                                                               No
                   11        SHORT_NAME                                                            Character                                                                                                 23                                                                                                               No
                   12        SHORTCUT                                                              Character                                                                                                  8                                                                                                               No
                   13        DRUG_TYPE                                                             Numeric                                                                                                    1                                                                                                               No
                   14        TOT_PKG_QTY                                                           Numeric                                                                                                    6                             3                                                                                 No
                   15        PKG_UNIT_MEA..                                                        Character                                                                                                  2                                                                                                               No
                   16        PKG_QTY                                                               Integer                                                                                                    4                                                                                                               No
                   17        DRUG_NAME_CO..                                                        Character                                                                                                  6                                                                                                               No
                   18        THERAPEUTIC_..                                                        Character                                                                                                 10                                                                                                               No
As you can see, the LONG field names are truncated, with ".." appended.

Is there a workaround so I can get an output WITH the long field names so I can easily cut and paste the names???

Thanks!!!
Tommy Tillman A+ NetWork+ MCP
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform