Viewing Database Information
The OpenBase Manager allows you to view and edit database table information using the Database Browser. To do this select a started database (one with a green dot) and click the View Data icon. This will bring up the Data Viewer tab shown in Figure 19.
Figure 19: Data Browser Window
The table names listed on the left of the Data Viewer tab offer an easy mechanism for choosing the tables you want to view. Selecting a table will show the data on the right.
The Data Viewer allows you to edit as well as view table content. As long as the record you select hasn't been locked by another user, you can double click to select and change information. The data browser keeps two people from editing the same row of information so that your changes will not be overwritten by other users.
If you are interested in seeing OpenBase system tables in addition to your own tables, you can check the “show all tables” checkbox. When you do this the table list is refreshed to include all of the system tables. We strongly recommend that you do not try to edit or change any of the information in the system tables directly.
The columns on the data viewer may be reorganized allowing you to view information in a different order. You can change the position of a column by pointing to the column's title, clicking and holding down the mouse button, and dragging the title to its new location. When you let go of the mouse, the columns will reorganize.
The field entitled Maximum Fetch at the top right enables you to specify the maximum number of rows you wish to be returned. Clicking the refresh button will refresh the display using the new maximum.
Clicking on the column titles at the top of the Data Viewer will sort the data by that column attribute.
Clicking on the Search button will bring up a search panel giving you the ability to narrow the search results. This is displayed below:
Figure 20: Data Viewer Search Window
The Data Viewer Search allows you to contrain the search by up to three different qualifiers. Use stars (*) to indicate wildcards for LIKE constraints.
The Query Editor tab on the Data Browser window allows you to create custom queries. This is useful if you have a select that you need to perform frequently. All you need to do is enter your SQL in the space provided (or choose a template to edit) and name it something you will remember. Only select statements are allowed. When you go back to the Data Viewer tab, your query will show up in the box just below the table list. Selecting the title will run the query.
Figure 21: Query Editor Window