DBViewer : A foreign-key-aware DataSet
This is a Freeware. Sources are available on request
Databases are not sequences of flat two-dimensional tables as viewed by traditional database browsers. Take altitude and take advantage of the THIRD DIMENSION.
DBViewer is foreign keys aware, that gives you the power to navigate from table to table, jumping from master tables to detail tables, linking automatically reference tables. More generally speaking, DBViewer is database structure aware. That is : If your database structure change, the way DBViewer displays the data will change accordingly.
New features include enhanced customization capabilities.
The DBViewer component is a TBDEDataSet descendant that uses other instances of itself to allow insertions and updates of your data. Each reference table can be in turn explored in depth.
Navigation is made easy thanks to a TreeView that shows at each step all master tables and fields. Each TreeView can be customized to hide or move some tables and fields, or add constraints to reference tables.
Customizations are stored in registry to build almost instantly powerful demo application.
Currently interfaced database types are Oracle, Informix, MS SQL, Sybase, Interbase, DB2, Access, Paradox, and dBase. If you enjoy DBViewer and wish to use it with another database type, please let us know.
New features will frequently be posted on this page as available.
Let navigate directly between cascade linked tables. For example go directly from a customer to the items he ordered without an intermediate step to the orders table. Combinations, and querying power are greatly increased. Click here to have a look
Follow this link to learn more about DBViewer querying capabilities
In case of difficulties with installation or use, as well as if you have any comment or suggestion, please mail to cdary@usa.net
DBViewer component 1.42 for Delphi 3 and 1.43 for Delphi 4. Size 122 Kb
DBViewer 1.42 executable (BDE >= 4.51 needed) size 338 Kb
DBViewer 1.43 executable (BDE >= 5.01 needed) size 414 Kb
If you don't have the BDE or SQL links you need Autonomous DBViewer executable 1.43 (Borland Database Engine and SQL links included) size 7 Mb
To use non-autonomous exe version you need BDE 4.51 or higher. If you have a previous BDE release you may Download a BDE update