Browse database data

Relational Data Browse is a simple and efficient way to view data from multiple related tables at a time, using only the mouse. In this example there are three tables each with one Browse Window. Between the Browse Windows are drawn the relating Foreign Keys ( with arrows ). The records which are displayed in the BOOKS_OUT_ON_LOAN relates to the current record from BOOK, and the records from USERS to the current one from BOOKS_OUT_ON_LOAN. Using the bottom buttons or by clicking an cell you can navigate between records. The child Browse Windows will be refreshed too.

To restrict the displayed records to the one which fullfills a given criteria, set column or table filters. They are similar with the WHERE clause used in the SQL statements. The filters dialog is available from the column pop-up menu. From the Browse Settings dialog you can set table related filters ( with complexer filter clause ) or ordering over multiple columns.

You can edit any data cell from the tables which has a Primary Key or Unique index. Double-click an cell to edit it. From the Browse Window menu you can choose to insert, delete or update a record.

Each insert, update or delete will is asking for confirmation before the effective operation. Like this you cannot change the database by mistake.