How do I add new fields to the database? [All editions]
Return to Introduction Previous Topic Next page

Planner

In Retain Planner, you use the Retain Manager application to manage your database. The initial Retain rdb (Retain DataBase configuration) file is supplied with many of the fields hidden. These can be unhidden by selecting Setup | Field Properties, and then unchecking the Hidden checkbox against the field you wish to use in Retain. The field in question can then be aliased to display whichever name you wish in the wallchart itself.

Standard

For the standard version, this can be done using the 'Restruct' utility that is provided with the software. You can open the table you want to amend and add/edit the relevant fields. Certain fields (such as 'Name', 'Initials' etc.) should not be re-named. Full details are given in the Retain manual.

Notes, DBI, Enterprise

In these editions, fields may be added to the underlying tables themselves.

Client-Server

You can add database fields as you wish in your own database by amending the database tables. It is vital that you mirror changes that you make in any of the main tables (RESRES, RESTASK, RESBOOK) in the associated _log table. For instance if you added the field RESRES.Gender, then you should also amend RESRES_LOG so that it also has an identically specified field called Gender.