Active Query Builder support area

when i get the formatted SQL the Group By columns are always arranged based on the order of the columns in the Select section

Avatar
  • updated
  • Completed

SELECT iminvloc_sql.item_no,
iminvloc_sql.loc,
Sum(iminvloc_sql.qty_on_hand)
FROM iminvloc_sql
GROUP BY iminvloc_sql.loc,
iminvloc_sql.item_no

If i format this query using QueryBuilder1.FormattedSQL, 

The formatting will change the positions of the GROUP BY columns to:

SELECT iminvloc_sql.item_no,
iminvloc_sql.loc,
Sum(iminvloc_sql.qty_on_hand)
FROM iminvloc_sql
GROUP BY iminvloc_sql.item_no,
iminvloc_sql.loc

 

Can this be prevented?

John

Avatar
Andrey Zavyalov, PM

Hello, 

This problem is already fixed in the latest version.