MapInfo Pro

Expand all | Collapse all

Improved SQL Syntax in MapInfo Pro v2019

  • 1.  Improved SQL Syntax in MapInfo Pro v2019

    Posted 5 days ago
    Edited by Peter Horsbøll Møller 2 days ago
      |   view attached
    A lot of work has gone into improving the SQL syntax in MapInfo Pro v2019.

    We have taken a good look a the many suggestions from the Ideas Portal and mixed that up with a few ideas of our own to come up with some powerful new features in the SQL Language of MapInfo Pro.

    These new features, of course, improve the Select statement, but we have also improved the Update as well as the Delete statement.

    For the Delete and Update statements, we have added support for expression in the Where clause.

    For the Select statement, we have made numerous improvements such as support for Table Alias, more flexible Join conditions, joins between base tables and temporary tables and support for a Limit clause.

    We have also added four new spatial aggregations that let you aggregate (or combine) the spatial objects if you group your records in a Select statement.

    I have included a small presentation that gives you an idea of these new improvements and how they could be used.

    Feel free to post any questions you may have.



    ------------------------------
    Peter Horsbøll Møller
    Pitney Bowes
    ------------------------------

    Attachment(s)



  • 2.  RE: Improved SQL Syntax in MapInfo Pro v2019

    Pitney Bowes
    Posted 2 days ago
    Hi Peter,

    There is a typo above. It is the delete and update statements that now support a where clause.

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



  • 3.  RE: Improved SQL Syntax in MapInfo Pro v2019

    Posted 2 days ago
    Edited by Peter Horsbøll Møller 2 days ago
    Thanks, Bob, I have changed the typo.
    Don't you just hate it when the Auto-Correction changes Delete into Insert :-)

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