ODBC: View or Edit SQL Statement

Displays current SQL statements used to query the ODBC database. This dialog is activated if you have selected the View or Edit SQL Query option on the ODBC: Data Query Finish menu, or your SQL statement has an error and you have chosen to edit it rather than cancel the ODBC query.

OK

Closes the dialog and runs the edited SQL statement.

Cancel

Closes the dialog and run the original/unedited SQL statement.

Tables

Insert a table name into the current SQL statement at the current cursor position using the ODBC Insert Table/Column Name dialog.

Columns

Insert a column name into the current SQL statement at the current cursor position using the ODBC Insert Table/Column Name dialog.

Revert

Restores the SQL statement to what was originally in the edit window.

Save edited text

If this is ticked, then after clicking Save, and the SQL statement completes, you will be prompted to save the query to a GDB file.

See also

SQL Statements
ODBC Databases
Create New Database Table from Spreadsheet
Insert Spreadsheet into Database
Merge Spreadsheet into Database
Run ODBC Export Link (GLK) file
Spreadsheet Export Menu
Spreadsheet Add Data Menu
Spreadsheet New Menu
Using ODBC with 64bit Windows
DBIMPORT procedure
DBEXPORT procedure

Updated on July 24, 2019

Was this article helpful?