The SQL Query Tool can be used to execute SQL code against the connection used by a generated DataStore.
The SQL Query Tool is described below.
The SQL Query Tool presents two views:
When you open the SQL Query Tool, you are prompted to supply the name of a data store and then a connection to the database is made. The name of the data store will be displayed on the window title.
In the illustration of the tool, you can see that a database connection has been made with a data store named CEDUC. In addition, it is evident that an SQL query has been entered and the results displayed in the information view.
SQL commands are entered in the text view.
To execute the command you must highlight the command, and then choose the Execute SQL menu item from the text view's pop-up menu.