--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en
---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mapinfo-l/1dd1c87d-0f2a-42c9-b0a4-e40fc358ac37n%40googlegroups.com.
The rumor has been written down in a #MapInfoMonday post:
Peter
From: mapi...@googlegroups.com <mapi...@googlegroups.com>
On Behalf Of Uffe Kousgaard
Sent: 11. august 2023 23:32
To: mapi...@googlegroups.com
Subject: Re: [MI-L] Programmatically defining which overlapping object appears on top
This message originated Externally. Use proper judgement and caution with attachments, links, or responses. |
To view this discussion on the web visit https://groups.google.com/d/msgid/mapinfo-l/5223c7e3-31ef-2703-3dc1-54cd8bd73e54%40routeware.dk.
Yeah, that should work too, I’d think
You may have some additional options using MapXtreme.
I’m not that well-versed in MapXtreme though.
From: mapi...@googlegroups.com <mapi...@googlegroups.com>
On Behalf Of Nick
Sent: 14. august 2023 16:07
To: MapInfo-L <mapi...@googlegroups.com>
Subject: Re: [MI-L] Programmatically defining which overlapping object appears on top
This message originated Externally. Use proper judgement and caution with attachments, links, or responses. |
Peter,
Thank you for the document link you sent.
Would these same methods apply when using MapXtreme 9.0 or higher? The application that I am using does have a "DateCreated" field which is a date/time field that I could try to sort by and see if I can get this to work.
--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en
---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
mapinfo-l+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mapinfo-l/7bdc080d-f2b0-45a3-911c-9e7ef3d94f11n%40googlegroups.com.
Peter,
Hi Nick
If it’s just one value you want to have on top, you can add an expression making sure that value is sorted last in your query.
Here’s my example:
My table has a column BYGN_UUID where some records don’t have a value.
I want these to appear on top of other records with a value.
I created an expression to assign the value 0 to the records with no values, and the other records I assign the value 1.
This the expression I add to the projection list in my Select statement:
Str$(IIf(b.BYGN_UUID = "", 0, 1)) As "OrderBy"
I use the IIf() function to compare the values in the column, and then return either 1 or 0 depending on the value.
I name this new column OrderBy and sort my query descending based on this column
Select b.*, Str$(IIf(b.BYGN_UUID = "", 0, 1)) As "OrderBy"
From Building_Rooftops As "b"
Order By OrderBy Desc
Into Selection
Cheers
Peter
From: mapi...@googlegroups.com <mapi...@googlegroups.com>
On Behalf Of Nick
Sent: 14. august 2023 21:20
To: MapInfo-L <mapi...@googlegroups.com>
Subject: Re: [MI-L] Programmatically defining which overlapping object appears on top
This message originated Externally. Use proper judgement and caution with attachments, links, or responses. |
Peter,
--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en
---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
mapinfo-l+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mapinfo-l/fbd95eb7-0ec4-4304-a032-119f16417566n%40googlegroups.com.