Query Behavior 32 bit vs 64 bit

Skip to first unread message

ICW Keith

Dec 5, 2022, 12:33:06 PM12/5/22
to MapInfo-L
Comparing 32 bit to 64 bit on managing queries.

I have existing code that manages open queries and close them, keeping the number of open queries to a minimum.   When the same code is executed in MapInfo 2021, something has changed, such that queries remain open.  Can these queries be managed (closed) without cluttering the list of tables.   Any insight into this issue would be appreciated.

Keith Tozier

ICW Keith

Dec 5, 2022, 12:49:15 PM12/5/22
to MapInfo-L
The mapbasic statement "Close Selection' seems to open a query.

ICW Keith

Dec 5, 2022, 12:56:32 PM12/5/22
to MapInfo-L
"Close table selection"

Peter Horsbøll Møller

Dec 5, 2022, 1:40:54 PM12/5/22
to mapi...@googlegroups.com

Hi Keith


I don’t see that behavior if I try to close the table selection through the MapBasic window. It just unselects the currently selected records.


I normally get the name of the query when I need to inspect it and then I close that name query:


sQuery = SelectionInfo(SEL_INFO_SELNAME)

‘**Do some work on the selection/query

Close Table sQuery


I have used this since… forever. I doubt I have changed this approach after the introduction of 64-bit.


Also if you run queries yourself in code and the user doesn’t have to see these, it’s recommend to use the keyword NoSelect as well as Hide:


Select *


Into _SOME_QUERY NoSelect Hide


This creates a query that doesn’t highlight the selected records and that doesn’t show up in the Table List.

This also have a great impact on performance if you loop over records in table and run multiple queries.





Peter Horsbøll Møller
Principal Sales Engineer - Distinguished Engineer


From: mapi...@googlegroups.com <mapi...@googlegroups.com> On Behalf Of ICW Keith
Sent: Monday, 5 December 2022 18.57
To: MapInfo-L <mapi...@googlegroups.com>
Subject: [MI-L] Re: Query Behavior 32 bit vs 64 bit


This message originated Externally. Use proper judgement and caution with attachments, links, or responses.


"Close table selection"

On Monday, December 5, 2022 at 12:49:15 PM UTC-5 ICW Keith wrote:

The mapbasic statement "Close Selection' seems to open a query.


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:
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at

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/6dc9fbbf-f791-4f93-8007-988bad79b5f0n%40googlegroups.com.

ICW Keith

Dec 5, 2022, 2:16:05 PM12/5/22
to MapInfo-L
I found the issue and it seems the table name spelling(case sensitivity) is what causes it the table name is "Selection" not "selection".

Thank you Peter.


Reply all
Reply to author
0 new messages