Query Behavior 32 bit vs 64 bit

[ICW Keith]

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

[ICW Keith]

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

 

[ICW Keith]

"Close table selection"

[Peter Horsbøll Møller]

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 *

From SOME_TABLE

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

 

 

—

Peter Horsbøll Møller

Principal Sales Engineer - Distinguished Engineer

Precisely.com

 

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

[ICW Keith]

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.

Keith