Afields()?
>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!!!