B
Brian K. Maher
Guest
Michael, The two types of ordering are _order order and _rpos order. Over time, changes to tables (add or remove fields, applying incremental .df files, manually changing the _order field – it defines the order that fields are displayed in when doing something like “display customer”) can end up where the _order and _rpos values, when sorted, do not match up (i.e. fielda has _order = 20 and _rpos = 5, fieldb has _order = 30 and _rpos = 3, etc). This has an effect when passing temp-tables across the wire because, if I remember correctly, _rpos is used to define the field order when transferring the data (it could be _order too, i haven’t needed to remember that in a long, long time). You can see the values in the Data Dictionary by looking at each fields “Order #” and “Position” fields. Most people define an include file which defines the fields to be used in the temp-table definition. This gives you one place to make changes and removes any issues related to the internal ordering. Brian
Continue reading...
Continue reading...