Thanks!
That got me thinking!!!
Here is what I did!
COPY STRUCTURE EXTENDED TO C:\TEST\FIELDS
USE c:\test\fields
LIST FIELDS FIELD_NAME,FIELD_TYPE, FIELD_LEN, FIELD_DEC TO FILE C:\TEST\FIELDS.TXT
And then loaded this into a text editor!
Thanks again!
Tommy
>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!!!
Tommy Tillman A+ NetWork+ MCP