Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Run SQL command directly

In Native SQL mode you can enter SQL commands that are not interpreted by Office, but are instead passed directly to the data source. If you do not display these changes in the design view, you cannot change back to the design view.

For native SQL, the SQL string is forwarded directly to the connected database system without a previous evaluation by Office. For example, if you access a database through an ODBC interface, the SQL string is passed to the ODBC driver and processed by it.

Run SQL command directly

Click the icon again to return to normal mode, in which the changes in the New Query Design are synchronized with the permitted changes through SQL.