When you first view a query results with columns in one order, then do a query where you want them in another order, the previous order is remembered.
E.g. run SELECT Col1,Col2 FROM THIS
Then run SELECT Col2,Col1 FROM THIS
Expected result: Col2 should be first, then Col1
Actual result: Col1 is first, then Col2
Workaround: Run "SELECT 1 FROM THIS", then the new query. Now they are in correct order.
Possible cause: I don't tear down the grid properly between queries.
When you first view a query results with columns in one order, then do a query where you want them in another order, the previous order is remembered.
E.g. run SELECT Col1,Col2 FROM THIS Then run SELECT Col2,Col1 FROM THIS Expected result: Col2 should be first, then Col1 Actual result: Col1 is first, then Col2
Workaround: Run "SELECT 1 FROM THIS", then the new query. Now they are in correct order.
Possible cause: I don't tear down the grid properly between queries.