ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Editors / Data model editor / Logical Data Model
  • Overview
  • Adding a new data file
  • Creating a new data file
  • Importing a preset description of data file
  • Color for the descriptions of data files
  • Security of an HFSQL data file
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Overview
The analysis is used to define the structure of the data files used by the project.
You can describe in the analysis:
Remark: To modify the description of a data file (or the description of its items):
  • Select the data file in the data model editor.
  • Select one of the following options from the popup menu:
    • "Data file description".
    • "Description of items".
Reminder: In a WINDEV, WEBDEV or WINDEV Mobile application, the "LDM" and "Analysis" terms are interchangeably used to define the structure of the database associated with a project.
For more details on how to handle a data file or item in the data model editor, see Operations on a data file and Operations on an item.
Adding a new data file

Creating a new data file

To create a new data file:
  1. On the "Analysis" tab, in the "Creation" group, click "New file". The data file creation wizard starts.
  2. Select "Create a new data file description". Go to the next step.
  3. Specify:
    • the logical file name. This name will be used to handle the data file.
    • the caption that briefly describes the file subject.
    • the representation of a record in the data file. This representation makes the questions asked when describing the links easier to understand. This option must be preceded by an indefinite article (A or AN).
    • whether the data file includes an "Automatic identifier" item. The value of this item is unique for each record and it is automatically calculated by the HFSQL engine.
      You can use:
      • an 8-byte ID. This type of identifier is mandatory for the replication of HFSQL servers.
      • a 4-byte ID.
      • an automatic UUID (128 bits). In this case, the identifier of each record corresponds to a 128-bit UUID (the UUID provides a unique non-sequential identifier).
      • an automatic UUID (256 bits). In this case, the identifier of each record corresponds to a 256-bit UUID (the UUID provides a unique non-sequential identifier).
  4. In the next step, specify the type of database associated with the data file. Depending on the type selected, this data file will be handled by the HFSQL engine, an OLE DB driver or a Native Connector (SQL Server, Oracle, etc.).
    If the type of database used does not correspond to HFSQL Classic (Network or Single-user), the wizard asks for the characteristics of connection to the database.
  5. The new data file becomes the current data file. The description window of the data file items opens automatically. It allows you to describe the file items.

Importing a preset description of data file

To import a preset file description:
  1. On the "Analysis" tab, in the "Creation" group, click "New file". The data file creation wizard starts.
  2. Select the option "Select a preset data file description".
  3. Choose the preset data file(s) to create.
    Preset data files
    The wizard also proposes associated data files that can be added as links.
  4. For each data file, select the items to keep. These items can be modified later.
  5. The preset data files are automatically inserted into the current analysis. The links between preset files are automatically established.
Color for the descriptions of data files
The following colors are used to quickly identify the types of data files in the data model editor:
  • Blue for the data files coming from a Native Connector.
  • Orange for HFSQL Client/Server data files.
  • Brown for HFSQL Classic data files.
  • Green for ODBC data files.
  • Gray for Hyper File 5.5 data files.
Security of an HFSQL data file
To ensure the security of an HFSQL data file:
  1. Open the file description:
    • Select the data file in the data model editor.
    • In the context menu, select "Data file description".
  2. In the "Details" tab:
    • Enable the encryption option for the data file, indexes, memos. Several encryption modes are available.
      Data protection
      The "Automatic (RC5 16 rounds if password)" option is selected by default when a data file is created. This option is used to automatically encrypt the data file if a password is defined by HPass on the data file.
    • Enable the "Enable a high-security level " option.
      Remark: This option is selected by default when creating a data file. This option allows you to request the password at each automatic modification of the data file.
  3. Generate the analysis.
  4. Specify a password for the data file with HPass.
  5. Encrypt the connection to the database in the connections described in the analysis, or programmatically with the Encryption property.
Remark: Advanced Encryption Standard (128-bit, 192-bit and 256-bit AES algorithm with OFB):
  • If the data file is encrypted using the AES algorithm, you need to use the same method to encrypt memos and indices.
  • If there is encryption that uses the AES algorithm, the option "Enable a high-security level " is automatically applied.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 02/29/2024

Send a report | Local help