Local Database Execute SQL

The Execute SQL tab is used enter SQL statements that are executed by the Local Database.

The statements can be used to define and manipulate information stored in a database table or index. Local Database table information can be added, viewed, updated, or deleted.

Using the Execute SQL tab

The Execute SQL tab provides fields for entering the SQL statement, function buttons and display information as follows:

Item Description
SQL Query The entry field for the SQL statement.
Most valid SQL statement can be used except CREATE statements such as CREATE TABLE and CREATE INDEX.
The SQL statements are not case sensitive.
For example:
  • SELECT * FROM [TABLE_NAME]
  • INSERT INTO [TABLE_NAME] VALUES (value1, value2, …)
  • UPDATE [TABLE_NAME] SET [COLUMN1]=[VALUE2] WHERE [COLUMN1]=[VALUE1]
  • DELETE FROM [TABLE_NAME] WHERE [COLUMN1]=[VALUE1]

After typing the SQL statement, you can either press the enter key or select the Execute Query button.

Using database Choose the type of Database that the SQL statement should be executed on.

This is determined by the Storage type of your Local Database Table.

Execute Query Executes the SQL statement currently displayed in the SQL Query field.
Load previous Query Recalls the previously executed SQL statement into the SQL Query field. Additional selects of this button will recall older SQL statements in a round robin fashion. 
Previous Queries A selection list of the previous queries that be used to recall a SQL statement.
Error Message Displays any error message encountered when the SQL statement is executed.
Data Returned Displays the information returned from the SQL statement.