[Progress Communities] [Progress OpenEdge ABL] Enabling SQL to use ORDER or POSITION for "select *"

[Stefan Marquardt]

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 This means there isn't a possibility (except D&L) to set the order of (new) fields for sql queries with "*", like "SELECT * from ..."

Continue reading...