I have a layer of points stored in a table in a database (Oracle 11g). The table have a boolean field called Supporting. I have a thematic layer coloring the supporting points white and the non-supporting points red. Supporting points are often very close to non-supporting points. Since I am mainly interested in the non-supporting points I want to draw any red points on top of any white points. Can I accomplish this in MapInfo 11.5?
I have tried opening the table window and sorting it. That does not seem to affect the drawing order. I have also tried adding an ORDER BY column in the SQL when using "Expert mode" in the dialog "Open alternative for DBMS table". This do affect the drawing order, but not in a predictable or useful way.
(English names of options and dialogs are translated from Swedish by me, so they may not exactly match the names in the english version of the software.)
أكثر...
I have tried opening the table window and sorting it. That does not seem to affect the drawing order. I have also tried adding an ORDER BY column in the SQL when using "Expert mode" in the dialog "Open alternative for DBMS table". This do affect the drawing order, but not in a predictable or useful way.
(English names of options and dialogs are translated from Swedish by me, so they may not exactly match the names in the english version of the software.)
أكثر...