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