Setting advanced properties
When you create a database, you can set certain advanced properties. The following information describes the properties that need to be set before data is entered.
About this task
| Advanced property | Reason for using this |
| Database Identifier |
If you want to identify entity and link records as belonging to this database, enter a short string of text (up to five characters). This is appended to the identifier of each new record; for example, PER475\GEN where GEN is the database identifier. This identifier is only necessary if you plan to perform operations outside iBase on records taken from different databases or if you use iBase database replication. Note: If you intend to use this feature, you must enter this string before you create any records in
the database. The field remains editable after database creation and the addition of records, but
any change you make will mean that records created before and after the change will have different
database identifiers.
Attention: The use of a database identifier has an impact on performance since the
database identifier is appended to the record identifier of every record.
|
| Extra Detail Field for Audit Log |
If you want the audit log to record the value of a particular field when recording actions that affect individual records, enter the name of a field (from this iBase database). The audit log always records the iBase Record ID so this extra recorded field is a free choice from data entered in iBase or imported from another database. Typically, the database designer sets up the schema so that the named field or standard field contains an external reference number or some other way of assessing the history or validity of a record. For example, this feature can be used to maintain an audit log with details of data and record identifiers imported from external databases. |
| Standard (SCC) Control | Leave the Standard (SCC) Control option selected. This gives each user access to all the records in the database, depending on their user permissions. For details of creating a database that is partitioned by case, see Creating a Case-Controlled Database. |
Other properties can be set, or changed with caution, at any time during the life of the database. For more information about all of these properties, see Summary of the Database Properties.
Procedure
- Click the Advanced tab to display the Advanced page.
- Select the properties that you would like to use.
- Click OK to create the database with the settings you have made.
What to do next
For any open database, you can view the properties by displaying the Database Properties dialog. When viewed in iBase Designer, you can change the Title, Description and, with caution, the settings displayed on the Advanced page.