Data Browser
DataBrowser allows you to work with the actual contents of
the database:
- Main Menu
- Main menu has a drop down box for every database, and displays the physical path too.
- Files
- The database files are listed in the drop down list, one for
each database. When one is selected the DataBrowser will immediately take you to the
Record browse table.
- Options: Report
- By clicking on the physical database in the third column it
will create an HTML-formatted Dictionary print. This report will file by file
alphabetically list all fields and indexes and their type, format, label, column-label.
This report is useful for printing and using as a desktop reference to the database.
- Options: Virtual System Tables
- This will only be accessible if the database has been set up
to provide them. This is essentially PROMON information, accessed through the database
fields and not through shared memory. Some useful information can be found here, like the
buffer hit-rate etc. This feature is will be fully implemented in later versions.
- Select Record (browse)
- This object will list eight columns of data fields from the
data file in ten rows at a time. It will also let you navigate, search and sort through
the dataset by available indexes.
- Navigation links: (First,Prev,Next,Last)
- These buttons will let you navigate through the current
dataset.
- Select File.
- Bring you back to the Main Menu.
- Add.
- Brings you to the edit screen with a newly created record
for you to modify.
- Count.
- By pressing Count it will count all records and then you
will be able to see (x to x+10 out of yy) information when using the browser.
- Find xxxxxxx where (index-field)
- This is a drop down list of the first index field in various
indexes. By selecting an index you can set the sorting order.
- Find xxxxxxx where index-field (value)
- By specifying the value here you can filter by a begins
value for character fields or equals value for integers, logical for logical fields and so
on.
- GO
- Executes the query entered.
- Edit data record.
- By clicking the first column of the records datarow
- Edit Record (detail)
- This object will list all data fields from the data record,
let you edit and save it. You can also delete and create new records.
- Edit fields
- View and edit the fields of the record.
- Save.
- Store the modifications and go back to Select Record.
- Reset.
- Reset values to what it was.
- Back.
- Just go back to the Select Record screen.
- Delete.
- Delete the record and go back to the Select Record screen.
NOTES:
Add-Record When records are created they
will be initialized with its default values and depending on the dataset values will be
created for index fields in order to keep them unique. However there is several problems
with data-types like ROWID, and the more testing is definitely needed. It seems to work
fine and it shouldn't be a problem often.
Index-field The index-field is the first
field of an index and sometimes I have seen it does not sort and filter right. It is nice
to have this functionality working 100%, but it is not necessary functionality and can be
hard to debug so I have delayed this one.
Main index