when i get the formatted SQL the Group By columns are always arranged based on the order of the columns in the Select section
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
Hello,
This problem is already fixed in the latest version.