Edit-DB Edit-DB
(c) Nigel Maddocks, 2007
Edit-DB ver 2.05.016, Doc ver 2.05.016

3. Tables

* Some of this section also applies to Views

To display a list of tables for a particular database or schema (and owner depending on database type), select Tables from Object type in the Object-type frame, having ensured that the other selections to the left, labelled Database or Schema (and Owner depending on database type), are completed.

Select a table from the list by clicking on the table name. Up to the first 100 records from the table are displayed by default. A limit is always applied to the number of records displayed but it can be modified by amending the selection at the top of the multi-record display.

Selecting the maximum number of records to display

A database column might be used to contain text, perhaps used for a letter and might contain line breaks. These line breaks will not be rendered as such unless the select textual display drop-down is set to Show new lines. A database column might be used to contain html in which case it will be rendered as if it were just ordinary html contained within the page - i.e. the html tags will be invisible within the browser. To display the html tags, set the select textual display drop-down to Render html.

Selecting how to display textual data

One of the difficulties of viewing long html tables within a web-browser is that the table headings drop off the page as one scrolls down. Edit-DB is different in this respect, as it dynamically keeps the column headings fixed to the top of the screen no matter how far you have scrolled down. In addition, if the table records are printed, the column headings are printed at the top of each page.

When displaying data in the multi record display, schema information is often cached in order to improve performance. If you are not seeing recent schema changes, then press the All Fields button button to refresh the schema cache.

The following sections explain how to define the record selection criteria as well as how to sequence the records. When you move back to displaying this table after viewing another table, the record selection and sequencing settings you had defined for this table are retained and re-applied by default.

3.1. Record selection
3.2. Record ordering
3.3. Record editing
3.3.1. In-line editing
3.3.2. Navigation within a set of records
3.4. Foreign key look-ups
3.5. Multiple-record Copying
3.5.1. Creating a New Table
3.6. Dates