Field help (ATBNBENREG)

The number of records field is used to define the size of the table in the database. This field is used to size the table being created or modified. This value is entered on the creation of the folder for each table created, from the result of the evaluation of the sizing formula. This formula itself uses variables where the values are entered in the folder parameters.

During the revalidation of a folder, the number of records is re-evaluated, but the result of the calculation is only re-written in this field if it is greater than the value found in the table ; thus, it is possible to modify this value, increase the size of the table and this value will be recovered in the case of folder revalidation. If however, it is decreased in size, it will be taken into account immediately if the table is manually validated with the help of the corresponding button, but once a revalidation of the folder is carried out, the calculated value that is greatest, will be used in place of the entered value. This behaviour has been defined for security reasons : for performance reasons and ease of use, it is in fact better to over size a table rather than under size it. It is not necessary to protect the modification of this field with an activity code.