MapInfo Pro

Sometimes we tend to forget to highlight some of the small improvements in the new releases of MapInfo Pro.

During December, I'll create a  number of posts focusing on exactly this: the small improvements that we have made in MapInfo Pro v2019.

Infotip shows the SQL statement for Queries in Table List

As you continue to create queries through a session in MapInfo Pro, you get more and more queries opened. Sometimes it can be hard to identify the exact query, you are looking for. This is especially the case if you haven't named your query tables but you have just used the generic Selection. In this case, you end up with a lot of query tables named Query1, Query2, Query3 and so on.

When you hover your mouse over one of these queries in the Table List in MapInfo Pro v2019, you will now see the SQL statement that generated the query table.

If you hover the mouse over a query table that was created by selecting the records using the Selector or another Select tool, the tooltip will tell you which base table the records were selected from.

We hope that you find this small improvement useful.

------------------------------
Peter Horsbøll Møller
Distinguished Engineer, Technical Ladder
Pitney Bowes Software & Data
------------------------------

Hi Peter,

Yes this tooltip very helpful. To double the power of this one it can easily be combined with naming the query via the "Into" clause so that the query tables have ​common names (not just "QueryX") . e.g. instead of "Query3" in your example it could be "qry_Parcels_840". Small change but big benefit!

Cheers, Ashley

------------------------------
Ashley Crane
Regional Director, Software Support
Pitney Bowes
------------------------------

Original Message:
Sent: 12-02-2019 21:54
From: Peter Horsbøll Møller
Subject: Infotip shows the SQL statement for Queries in Table List in MapInfo Pro v2019

Sometimes we tend to forget to highlight some of the small improvements in the new releases of MapInfo Pro.

During December, I'll create a  number of posts focusing on exactly this: the small improvements that we have made in MapInfo Pro v2019.

Infotip shows the SQL statement for Queries in Table List

As you continue to create queries through a session in MapInfo Pro, you get more and more queries opened. Sometimes it can be hard to identify the exact query, you are looking for. This is especially the case if you haven't named your query tables but you have just used the generic Selection. In this case, you end up with a lot of query tables named Query1, Query2, Query3 and so on.

When you hover your mouse over one of these queries in the Table List in MapInfo Pro v2019, you will now see the SQL statement that generated the query table.

If you hover the mouse over a query table that was created by selecting the records using the Selector or another Select tool, the tooltip will tell you which base table the records were selected from.

We hope that you find this small improvement useful.

------------------------------
Peter Horsbøll Møller
Distinguished Engineer, Technical Ladder
Pitney Bowes Software & Data
------------------------------

That's a good suggestion, Ashley.

Might be good to pull together a post on small tips on improving your SQL statements!

------------------------------
Peter Horsbøll Møller
Distinguished Engineer, Technical Ladder
Pitney Bowes Software & Data
------------------------------

Original Message:
Sent: 12-03-2019 21:04
From: Ashley Crane
Subject: Infotip shows the SQL statement for Queries in Table List in MapInfo Pro v2019

Hi Peter,

Yes this tooltip very helpful. To double the power of this one it can easily be combined with naming the query via the "Into" clause so that the query tables have ​common names (not just "QueryX") . e.g. instead of "Query3" in your example it could be "qry_Parcels_840". Small change but big benefit!

Cheers, Ashley

------------------------------
Ashley Crane
Regional Director, Software Support
Pitney Bowes

Original Message:
Sent: 12-02-2019 21:54
From: Peter Horsbøll Møller
Subject: Infotip shows the SQL statement for Queries in Table List in MapInfo Pro v2019

Sometimes we tend to forget to highlight some of the small improvements in the new releases of MapInfo Pro.

During December, I'll create a  number of posts focusing on exactly this: the small improvements that we have made in MapInfo Pro v2019.

Infotip shows the SQL statement for Queries in Table List

As you continue to create queries through a session in MapInfo Pro, you get more and more queries opened. Sometimes it can be hard to identify the exact query, you are looking for. This is especially the case if you haven't named your query tables but you have just used the generic Selection. In this case, you end up with a lot of query tables named Query1, Query2, Query3 and so on.

When you hover your mouse over one of these queries in the Table List in MapInfo Pro v2019, you will now see the SQL statement that generated the query table.

If you hover the mouse over a query table that was created by selecting the records using the Selector or another Select tool, the tooltip will tell you which base table the records were selected from.

We hope that you find this small improvement useful.

------------------------------
Peter Horsbøll Møller
Distinguished Engineer, Technical Ladder
Pitney Bowes Software & Data
------------------------------

Also, the tooltip for Selection shows you what table the selection is based on.


------------------------------
Bob Fortin
Software Architect and Distinguished Engineer
------------------------------

Original Message:
Sent: 12-02-2019 21:54
From: Peter Horsbøll Møller
Subject: Infotip shows the SQL statement for Queries in Table List in MapInfo Pro v2019

Sometimes we tend to forget to highlight some of the small improvements in the new releases of MapInfo Pro.

During December, I'll create a  number of posts focusing on exactly this: the small improvements that we have made in MapInfo Pro v2019.

Infotip shows the SQL statement for Queries in Table List

As you continue to create queries through a session in MapInfo Pro, you get more and more queries opened. Sometimes it can be hard to identify the exact query, you are looking for. This is especially the case if you haven't named your query tables but you have just used the generic Selection. In this case, you end up with a lot of query tables named Query1, Query2, Query3 and so on.

When you hover your mouse over one of these queries in the Table List in MapInfo Pro v2019, you will now see the SQL statement that generated the query table.

If you hover the mouse over a query table that was created by selecting the records using the Selector or another Select tool, the tooltip will tell you which base table the records were selected from.

We hope that you find this small improvement useful.

------------------------------
Peter Horsbøll Møller
Distinguished Engineer, Technical Ladder
Pitney Bowes Software & Data
------------------------------