![]() |
![]() |
![]() |
![]() |
Building SQL Queries
Once a connection to a database has been made, it is available to do queries, updates, and other database operations. The SQL builder page provides tools to help with SQL queries.
There are three major areas of the SQL builder page:
The Schema Tree
On the left side of the SQL Builder page is the Schema Tree. This is a tree representation of all the database tables available to the user. If user chooses a table, all of the information in it will be displayed in the ResultSet Area.
The Statement area
The area on the upper right of the SQL Builder page is the Statement Area. SQL commands may be typed here.
To help organize different SQL commands, they can be stored as individual queries. Whenever a new command is to be typed in, the "Create a new Query" button should be used to produce a new query area. At the top of the area is a combobox which allows the user to switch between queries and also edit their names. Finally, if a query is no longer needed, it may be deleted by using the "Delete Query" button.
The Code Sourcerer can also be used to produce SQL queries. Note that the code generated by the Code Sourcerer will replace any code in the current query of statement area.
Pressing the "Execute Query" button will send the SQL command to the database. The ResultSet (if any) will be displayed below, in the ResultSet Area.
The ResultSet Area
ResultSets from the database will be displayed in table format in the ResultSet Area on the bottom of the SQL Builder page. Any error messages from the database will also be displayed here. Note that some database operations will not give any feedback in this area.
Data Representations, Inc. http://www.datarepresentations.com support@datarepresentations.com sales@datarepresentations.com |
![]() |
![]() |
![]() |
![]() |