Enter SQL Query Dialog Box - MapInfo_Pro - 2023

MapInfo Pro Help

Product type
Software
Portfolio
Locate
Product family
MapInfo
Product
MapInfo > MapInfo Pro
Version
2023
Language
English
Product name
MapInfo Pro
Title
MapInfo Pro Help
First publish date
1985
Last updated
2023-09-12
Published on
2023-09-12T16:39:16.995549

The Enter SQL Query dialog box lets you create complex queries using the standard DBMS SQL syntax. To type in multi-line formatted SQL do the following:

  • To get a new line click Enter.
  • To tab, press Ctrl+Tab.
  • To cut and paste from the clipboard, press Ctrl+X to cut, Ctrl+C to copy, and Ctrl+V to paste.

OK

Click to move to the final dialog box of the wizard.

Cancel

Click to cancel the query. You return to the step in the wizard where you originally invoked the Expert dialog box.

Load

Click to load an SQL statement that has been saved in a file. The Load button activates the Load SQL Query dialog box. This dialog box provides you with access to existing files containing SQL statements (*.sql files). When you load an SQL file, its format is preserved.

Save

Click to save the SQL statement in a file for later use. The Save button activates the Save SQL Query dialog box. Use this dialog box to save newly constructed SQL statements, or modifications to existing statements. When you save an SQL file, its format is preserved.

Once saved, the SQL statement appears in the list of available *.sql files in the Load SQL Query dialog box.

Last Query

Click to load the last query that was executed.