Subject display structure From Paul Nielsen <pnielsenz@cs.com> Date Wed, 23 Dec 2020 11:45:52 -0500 Newsgroups dbase.getting-started Attachment(s) MLG structure.png When I issue the command display structure in the command window, the Index column is all N for my table with several simple iindexed fields. But the modify structure command shows the indexed fields properly (see attachment) The Dbase 10 help example shows that an indexed field should show a Y if the field is indexed (for the table fish.dbf) But when I locate this table the result is Structure for table   C:\ProgramData\dBASE\Plus10\Samples\fish.dbf Table type            DBASE Version               7 Number of rows        10 Last update           03/05/2013 ------------------------------------------------------------------------- Field  Field Name                        Type          Length  Dec  Index     1  ID                                AUTOINCREMENT      4           N     2  Name                              CHARACTER         30           N     3  Species                           CHARACTER         40           N     4  Length CM                         NUMERIC            8    2      N     5  Description                       MEMO              10           N     6  Fish Image                        BINARY            10           N ------------------------------------------------------------------------- ** Total **                                               103 As it turns out, my copy of FISH is not indexed, according to modify structure. But if I modify the structure to make it indexed on Name and Species, then the Index column shows both of these are indexed. If I return to my table, which has about 45000 entries, and use modify structure, and just enter the JOB field and set it again to be indexed ascending, there is a delay of about 10 seconds while the mdx file is recreated, but when this is done, the Index column still shows "N" for JOB. I get exactly the same result for my table with dBase 2.61. My version of dBase 10 is 10.3l.1.0 b2594, The header and two lines for display structure of my table is Structure for table   D:\dbf\mlg.dbf Table type            DBASE Version               4 Number of rows        44123 Last update           12/23/2020 ------------------------------------------------------------------------- Field  Field Name                        Type          Length  Dec  Index     1  JOB                               CHARACTER         10           N     2  DS                                DATE               8           N Is it possible that the table level of 4 in my table is effecting the operation of display structure? Thanks for any help. Paul