[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Which entry in a df file defines the position of a field in the SQL schema or "SELECT *

[steve pittman]

Hi Stefan, For "select *" field order ,in the query result set, OE sql always uses the "physical order" of the fields defined in the table queried. The physical order is the order in which the fields were defined. When a field is added to the set of fields in a table, the new field is always last in physical order. OE sql does not use ORDER or POSITION. I believe that POSITION in the .df corresponds to _Field._field-rpos in the db schema. Enabling sql to use ORDER or POSITION for "select *" would be a feature enhancement, for our Product Management folks to consider. hope this helps, ....steve pittman [OE sql software architect]

Continue reading...