PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

  • Overview
  • Adding a record into a data file
  • Modifying a record in a data file
  • Deleting a record from a data file
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
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 the operations affect items found in linked files (in the data model editor), we recommend that you enable integrity and duplicate management.
The integrity and duplicate management are enabled by default.
The integrity management is enabled only if the source analysis of the file is known: the integrity management is not enabled if the file is directly opened in explorer by WDMap.
Notes:
  • To enable the management of integrity, select "Parameters .. Management of integrity".
    Caution: You may sometimes want to manually locate the files linked to the file used. To locate the missing files manually, click and select the directory of each file taking part in the management of integrity for the current file.
  • To enable the management of duplicates, select "Parameters .. Management of duplicates".
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Adding a record into a data file
To add a record into a data file:
  1. Display the data file into which the record must be added (see Viewing the records found in a data file for more details).
  2. Select "Edit .. Add a record" (or click the first empty row of the viewing table). A new row is added to the viewing table.
  3. In this new row, enter the values corresponding to the new record.
    Note: The arrow keys allow you to move from a column to another one.
  4. Click a different row to validate the addition.
    Note: The HFSQL security mechanism will be triggered if a duplicate error occurs while the management of duplicates is enabled. Modify the values and validate.
Note: WDMap can also be used to duplicate a record:
  1. Select the record to duplicate.
  2. Select "Edit .. Duplicate a record" (or press [Ctrl]+[D]).
Modifying a record in a data file
To modify a record in a data file:
  1. Display the data file where the record must be modified (see Viewing the records found in a data file for more details).
  2. Select the record to modify in the viewing table.
  3. Click the column to modify. The input cursor is displayed.
  4. Enter the new value.
  5. Click another row to validate the modification.
    Note: The HFSQL security mechanism will be triggered if a duplicate error occurs while the management of duplicates is enabled. Modify the values and validate.
Batch processing: WDMap allows you to modify all the displayed records in a single operation:
  1. Select "Edit .. Modify these records".
  2. Select "<Initialization>" in the rows corresponding to the items to modify.
  3. Enter the new values.
Deleting a record from a data file
To delete a record from a data file:
  1. Display the data file from which the record must be deleted (see Viewing the records found in a data file for more details).
  2. Select the record to delete in the viewing table.
  3. Select "Edit .. Delete the record" (or press the [Del] key).
  4. Confirm the deletion.
    Note: An error message is displayed if an integrity rule is applied to the deleted record while the integrity management is enabled. The record will not be deleted.
Tip: All the displayed records can be deleted in a single operation via "Edit .. Delete all the records".
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment