[progress Communities] [progress Openedge Abl] Add Indexes To _file And _index

[Rob Fitzpatrick]

I often want to iterate over the application-specific records in _file or _index, e.g.: for each _file no-lock where _tbl-type = 't': // do stuff end. for each _index no-lock where not _index-name begins "_": // do other stuff end. It would be nice to have a new _index field, analogous to _tbl-type, to distinguish between system indexes and application indexes. It would be nice to have an _index index on that field, and an _file index on _tbl-type, such that queries on application objects don't require a table scan.

Continue reading...