| Subject | Re: display structure |
| From | Ken Mayer <dbase@nospam.goldenstag.net> |
| Date | Wed, 23 Dec 2020 11:01:37 -0800 |
| Newsgroups | dbase.getting-started |
On 12/23/2020 8:45 AM, Paul Nielsen wrote: > 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? Are the indexes complex indexes with names other than the fieldname? If so this command can't do that. You would need something more involved. I am trying this with dBASE 2019 and it works fine on a table with lots of index tags, but the are all simple indexes. Ken -- *Ken Mayer* Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm | |