Applications

 

Help Sections:

General

Writer

Impress

Math

Draw

Calc

Base

Basic

Execute SQL statement

Opens a dialog where you can enter an SQL command for administering a database.

Executing SQL Commands

You can only enter administration commands in this dialog, such as Grant, Create Table, or Drop Table, and not filter commands. The commands that you can enter depend on the data source, for example, dBase can only run some of the SQL commands list here.

Command to execute

Enter the SQL administration command that you want to run.

For example, for a "Bibliography" data source, you can enter the following SQL command:

SELECT "Address" FROM "biblio" "biblio"

For more information on SQL commands, please consult the documentation that came with the database.

Previous commands

Lists the previously executed SQL commands. To run a command again, click the command, and then click Run.

Status

Displays the results, including errors, of the SQL command that you ran.

Run

Runs the command that you entered in the Command to execute box.

Close

Closes the dialog.

Index

SQL, executing SQL statements

databases, administration through SQL

This help text is published from the OpenOffice-Help files under the Public Documentation License 1.0.