Table Maintenance
Introduction
Warning !
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 designed for developers and should not under any circumstances be left in the hands of unauthorised users. Inappropriate use is likely to corrupt the integrity of the data stored in the database.
Only users having the administrator profile (defined by the ADMUSR variable) can execute this function.
All tables can be viewed, and the majority of them can be modified using this function.
Method of operation
The name of the folder is entered, then the name of the table that is to be maintained. By default, the current folder is proposed, however it is possible to give the name of another accessible folder, using the following syntax :
FOLDER (the name of the folder directly : in this case, the folder is supposed to be directly accessible on the same server and the same service).
server@FOLDER (the network name for the server where the folder is located should be given : An adxd service must work on the current service number to allow the connection).
server:service@FOLDER (same principle as above, but the service number can be different. This gives, for example, the syntax server_01:1802@DEMO).
Warning: the last two syntaxes assume that there exists on the remote server a folder having the same name as the folder from where the function is run (even if it is not in this folder that the operation will be launched). This condition is always filled when starting in the supervisor folder, because every installation is assumed to have a folder of this type (whose name, according to the software, is X3, PAYE, GX) installed as a minimum. Therefore it is advised that this syntax is used only in this case. In addition, according to the network configurations, entering an incorrect network name can trigger a long wait time after entry of the field (since the check on server existence is made on the network, a delay in the order of one minute, sometimes several minutes occurs before an error message is received).
The table fields are displayed over 15 tabs (not all are necessarily filled, because this depends on the number of fields in the table). They are presented in alphabetical order. The fields making up the principal key for the record are shown below. It is therefore possible to:
Choose a record by entering its key, followed by TAB. Warning, if this record does not exist, the user is placed in creation mode, it is also not advisable to use the Return key after entering the key, because this will create the record if the key does not exist.
Move through the table with the aid of the radio buttons.
Modify the values and validate them using the button, or by successive Tab or by Return.
Create a new record by entering a non-existent key and assigning all the values.
Delete the current record using the .
Change the current table using the following button . In this case, the initial choice window will be displayed, and a new screen screen appropriate for the table being maintained will be displayed.
Set a filter to only select certain lines in the table, with the help of the Selection / Selection choice in the menu bar. The first record greater or equal to the current value (the first if there is only one) will be displayed. If no record greater or equal to the current value exists, the Start/End of record message is displayed and there is no current record. Warning, this does not necessarily mean that no record responds to the criteria (for assurance use the radio button that loads the first record; if the message is lost, there is no record responding to the criteria).
Notes
This maintenance function does not logically lock a record. In this way, it is possible to modify a record when a user is in the process of modifying it using the standard functions.
Fields of the Local menu type must be entered here in the form of numeric values (no control is made with respect to the maximum number of values possible in the local menu in question).
A detailed log of maintenance operations carried out in this way is generated by the system.
Error messages
Error on selection criterion
(followed by a more detailed message)
The selection criterion syntax is incorrect, or the criterion makes reference to non-existent fields.
Tables used
All the database tables can be viewed or modified by this function.
Screen management
Header
Fields
The following fields are present on this tab :
Block number 1
| It used to define a name associated with each record. |
| Code identifying the current record. |
Block number 2
| It used to define a name associated with each record. |
| Code identifying the current record. |
Block number 3
| It used to define a name associated with each record. |
| Code identifying the current record. |
Block number 4
|
|
| Code identifying the current record. |
Close
Tab Page 1
Fields
The following fields are present on this tab :
Block number 1
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 2
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 3
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Close
Tab Page 2
Fields
The following fields are present on this tab :
Block number 1
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 2
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 3
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Close
Tab Page 3
Fields
The following fields are present on this tab :
Block number 1
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 2
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 3
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Close
Tab Page 4
Fields
The following fields are present on this tab :
Block number 1
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 2
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 3
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Close
Tab Page 5
Fields
The following fields are present on this tab :
Block number 1
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 2
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 3
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Close
Tab Page 6
Fields
The following fields are present on this tab :
Block number 1
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 2
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 3
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Close
Tab Page 7
Fields
The following fields are present on this tab :
Block number 1
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 2
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 3
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Close
Tab Page 8
Fields
The following fields are present on this tab :
Block number 1
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 2
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 3
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Close
Tab Page 9
Fields
The following fields are present on this tab :
Block number 1
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 2
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 3
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Close
Tab Page 10
Fields
The following fields are present on this tab :
Block number 1
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 2
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Block number 3
|
|
| Enter the key values to find the record and if necessary modify it. Warning : The information that will be entered in this page corresponds to the fields defined in the table dictionary. There is no control of the entry and it is necessary to take certain precautions (respect of upper and lower case, spaces ...). It is better to use the key TAB to check for the existence of a field in preference to the ENTER key that could create a record by error. For this same reason, it is preferable to use the selection function to search for a record. Finally, there is no lock management and a record can be modified when it is already being processed in another session. |
Close
Tab Text
Fields
The following fields are present on this tab :
Block number 1
|
|
Block number 2
|
|
Close
Tab Image
Fields
The following fields are present on this tab :
Block number 1
|
|
Block number 2
|
|
Close
Tab Bureaucratic
Fields
The following fields are present on this tab :
Block number 1
|
|
Block number 2
|
|
Close