Demo Notes - DB Admin
|
- Click "DB Admin" from the PDA Demo Menu. Enter the magic word (the word is "dba") and click
the "I Know It" button. The XML file containing the application
will be downloaded and cached. (This only happens the FIRST time, unless you "Reset"
the cached apps).
- An initial host request will be performed to obtain a list of connected databases
and, if there is only one, a list of the table names in that database. If there were
multiple databases connected, you could select one and then get a list of tables.
- Select a table name from the combobox, such as "Customer", then click "View Contents".
A host request will be performed to obtain schema information for the fields in this table,
which are displayed in a table in a new window. The columns include field name, label,
data type, format, decimals, and help message.
- Also note the useful column titled "Field Value". By using the First/Next/Prev/Last
buttons, you can browse through all the records (rows) of this table and see the field
values of each record.
- To limit your browse to certain records, click the "Filter" button.
The utility has automatically selected all fields that are leading index key components
and any word indexed fields. You can construct a boolean filter using one of the key
fields in a comparison and/or one of the word indexed fields in a word match. This will
be applied on any subsequent browsing, until you click "Clear Filters" on this window.
- To see all the information about a field in an easier-to-read format, click on a
row that contains a field, then click "Detail".
- To change one field's value in the currently displayed record, click on a
row that contains a field, then click "Update". The field name and data type will
be displayed in a new window, along with a textarea in which you can change the
current field value. Click "Submit" to save the new value, or click "Refresh" to
reset the entry area to the current value. Click "Back" when done.
- To end the demo and return to the demo menu, click "Exit".
|
|
