Why can I put in larger numbers in Defaults Manager than I can in Retain? [DBI, CS]
Return to Introduction Previous Topic Next page

The maximum length of a field in Retain is determined by the length of the underlying field in the actual database table, though older versions of Retain will stop you entering more than 255 characters in a field anyway. If you need to store larger pieces of information, you can create document links.

If you decide to make a change to the length of a field in your database it is vital that you also change the length of the same field in the associated _LOG file. For example, if you change the length of the SKILLS field in the RESRES table from 20 characters to 30, you must also change the length of the SKILLS field in the RESRES_LOG table. The Defaults Manager utility has a standard field length for all fields, which is not necessarily the same as that of the field in the database itself.