Column Maintenance
This function is used to modify the data in any table in the database, without making checks on the data other than that coherency checks introduced by the internal types of the data (date, character string, numeric values). This represents a maintenance operation essentially intended for developers and should not under any circumstances be left in the hands of unauthorized users. Its inappropriate use is likely to corrupt the integrity of the data stored in the database.
Only users having the admin profile (defined by the ADMUSR variable) can execute this function. In addition, if the ASIGMNT setup is set to Yes, a confirmation will be required by re-entering the password and a reason code.
All tables can be viewed, and the majority of them can be modified using this function.
Unlike the record maintenance function, this maintenance function does not allow the creation of records. It can be used however, to modify a limited number of fields more globally, because the fields are displayed in columns, each record being displayed as in a line in a grid.
Legal notice
This type of function is a development function whose use is probibitted in a standard use framework.
Any legal consequences arising from the use of development tools on databases containing data which it is prohibitted by law to modify will be under the full responsibility of the customer. For further information, refer to the corresponding annex.
Screen management
On entry into the function, a window opens. Firstly the folder code and the name of the table to be maintained are entered. The list of fields in the table appears in the grid at the bottom of the screen.
Entry screen
Presentation
The selection and display criteria related to the data that the user wants to see and modify should be defined.
Once carried out, a new window is automatically created, opened and loaded with the first records from the table. The following are accessible using the radio buttons.
Once this display is carried out, the user can:
- Mass modify the fields in the records by entering them in the grid.
- Validate the current record by clicking on.
- Move through the table thanks to the radio buttons.
- Modify any filter criterion already defined, or by creating another, in the form of an expression that make the fields, the functions and the constants in the table interact. This is made using the Selection menu.
Close
Fields
The following fields are present on this tab :
Block number 1
| Define the folder code, as it is defined in the folders table, in which the work will be carried out. |
Block number 2
| Define the code for the database table that is to be worked on. |
| Used to define a selection formula to filter the data to be processed. This filter criterion can be used on fields coming from the context (notably the fields from the tables, constants, functions and operators) The formula assistant can be called on this field to aid the definition. |
| If the different fields in the table are displayed in this column |
| Use this field to assign a description to each record. |
| With regard to each field, specify which are the fields that should be displayed or Entered during maintenance. The fields constituting the principal key for the table are always displayed; those that defined as hidden do not appear in the entry grid. It should be noted that, by right click on the fields in the Entry type column, it is possible to globally update all the fields (other than those linked to the principal key of the table) with one of three values Enter, Display, or Hidden. |
Close