White_Banner.jpg - 40746 Bytes


Database Command Window


CMD.jpg - 60000 Bytes


This is the Command window. The command window provides the user with the ability to view the database tables, and execute SQL commands on those tables. Running SQL commands on the tables is not necessary for normal operation, it might however be useful for sorting table data for viewing.

The Active Query button is the query button to use when executing a query that returns table information (a curser to table data). The Exec Query button is the button to use when executing an SQL statement that doesn't return a curser such as a delete statement.

The drop down menu contains a list of the database tables. Selecting a table will pull that table up and display the table data in the grid above. The "Load Table" button allows the user to type a table name in the text entry area and load it by pressing the Load Table button.

Finally, the blue bars along the side indicate that a database connection has been established.