SQL Execution

<< Click to Display Table of Contents >>

Navigation:  Main Form Interface > SQL Statements >

SQL Execution

Previous pageReturn to chapter overviewNext page

Executing the SQL statement

Clicking the [Run SQL] button will execute the currently focused SQL statement.

The statement must match the current open database.

One or several SQL statements may be included in the same SQL tab to be executed sequentially.

If the final SQL statement is a SELECT statement, the result will be displayed in the output grid below.

If the statement is a clean single table SELECT, the table can be opened in editable Live Request view enabling you to edit, add/insert and delete records.

If the statement contains manipulated data, JOINs or UNIONs the Live Req. check will be ignored, and the readout will be in read only view.

See also SQL Auto Conversions.

AbsoluteSQL Application Manual - 03 April 2024 - Copyright © 2011 - 2024 Niels Knabe