|
|
|
|
|
|
|
|
|
|
- Overview
- Adding a record into a data file
- Modifying a record in a data file
- Deleting a record from a data file
WDMap: Add, modify and delete records in a data file
 Not available with this kind of connection
WDMap allows you to perform simple operations (addition, modification or deletion) on the records found in a data file. These operations can only be performed while developing the application (WDMap cannot be redistributed). For example, you can add, modify or delete records before the corresponding windows are created in your application. You can also directly run the test of your processes. Caution: If you need to manipulate fields in linked files (in the data model editor), it is advisable to activate integrity and duplicate management..
The integrity management and the duplicate management are enabled by default.
Integrity management is only activated if the original analysis of the file is known: integrity management is not activated if the file is opened directly in the explorer with WDMap. Remarks: - To enable the management of integrity, select "Parameters .. Management of integrity".
Caution: It is sometimes necessary to manually locate the files linked to the file being manipulated.. To locate the missing files manually, click  and select the directory of each file taking part in the integrity management for the current file. - To enable the management of duplicates, select "Parameters .. Management of duplicates".
Adding a record into a data file To add a record into a data file: - Display the data file into which the record will be added (for more details, see Viewing the records found in a data file).
- Select "Edit .. Add a record" (or click the first empty row of viewing table). A new row is added to the viewing table.
- In this new row, enter the values corresponding to the new record.
Note: To move from one column to another, use the arrow keys on the keyboard. - Click a different row to validate the addition.
Remark: If duplicate handling is enabled and a duplicate error is detected, the HFSQL security mechanism is triggered.. Modify the values and validate.
Note: WDMap also allows you to duplicate a record: - Select the record to duplicate.
- Select "Edit .. Duplicate a record" (or press Ctrl + D).
Modifying a record in a data file To modify a record in a data file: - Display the data file where the record will be modified (for more details, see Viewing the records found in a data file).
- Select the record to modify in the viewing table.
- Click the column to modify. The input cursor is displayed.
- Enter the new value.
- Click another row to validate the modification.
Remark: If duplicate handling is enabled and a duplicate error is detected, the HFSQL security mechanism is triggered.. Modify the values and validate.
Batch processing: WDMap allows you to modify all displayed records in a single operation: - Select "Edit .. Modify these records".
- Select "<Initialization>" in the rows corresponding to the items to modify.
- Enter the new values.
Deleting a record from a data file To delete a record from a data file: - Display the data file from which the record must be deleted (for more details, see Viewing the records found in a data file).
- Select the record to delete in the viewing table.
- Select "Edit .. Delete the record" (or press the Del key).
- Confirm the deletion.
Note: An error message appears if integrity is managed and an integrity rule is applied to the deleted record.. The record will not be deleted.
Tip: All records viewed can be deleted in a single operation using the "Edit . Delete all records".
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|