Are we able to change the length of fields? [All editions]
Return to Introduction Previous Topic Next page

Retain Planner

You cannot change the length of the fields in Retain Planner.


Retain Standard

In Retain Standard you should use Retain Restructure.

fieldlength

Client-Server

You can alter the length of the 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 altered the field RESRES.Location from being 20 characters to being 30 characters long, then you should also amend RESRES_LOG.Location to being 30 characters long. We would recommend that certain database fields are not amended, these are listed in the Implementation Guide. You can also add additional fields.


Retain Notes, DBI, Retain Enterprise

You can alter the length of the database fields as you wish in your own database by amending the database tables. We would recommend that certain database fields are not amended, these are listed in the Implementation Guide.