When you use Micromine’s ODBC link (not the Microsoft
you can include an SQL instruction to sort the data. This should prevent any problems with order/sequence of the data.
At the bottom of the ODBC dialog window a SQL instruction can be added to sort the data by toggling on the "Append a clause to the SQL statement” option box and adding a Sort instruction at the end of the SQL query.
An example of a ANSI-standard SQL syntax database clause is:
ORDER BY HOLE,FROM;
The above example sorts the data by the fields "HOLE" and "FROM" respectively. It is a useful example as the majority of sorting issue Micromine users have faced has been resolved by adding this clause to this clause to the end of the SQL query.
Customer support service by UserEcho