• a new data file.
• a preset data file, supplied with WINDEV, WEBDEV and WINDEV Mobile.
• a data file imported from an external database (also called "Third-party database").
• a data file imported from an earlier WINDEV version.

• Select the data file in the data model editor.
• Select one of the following options from the popup menu:
  • "Description of data file".
  • "Description of items".

Creating a new data file

1. On the "Analysis" pane, in the "Creation" group, click "New file". The data file creation wizard starts.
2. Select "Create a new description of data file". 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 improves the legibility of questions asked when describing links. 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.
     
     Versions 18 and later
     You can use:

     • an identifier on 8 bytes. This type of identifier is mandatory for the replication of HFSQL servers.
     • an identifier on 4 bytes.
     New in version 18
     You can use:

     • an identifier on 8 bytes. This type of identifier is mandatory for the replication of HFSQL servers.
     • an identifier on 4 bytes.
     You can use:
     • an identifier on 8 bytes. This type of identifier is mandatory for the replication of HFSQL servers.
     • an identifier on 4 bytes.
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 created data file becomes the current data file. The file items description window opens automatically. It allows you to describe the file items.

Importing a preset description of data file

1. On the "Analysis" pane, in the "Creation" group, click "New file". The data file creation wizard starts.
2. Select the option "Select a description among the preset data files".
3. Choose the preset data file(s) to create.
   
   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.

• 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.

1. Open the file description:
   • Select the data file in the data model editor.
   • Select "Description of data file" from the popup menu.
2. In the "Details" tab:
   • Enable the encryption option for the data file, indexes, memos. Several encryption modes are available.
     
     The option "Automatic (RC5 16 rounds if password)" 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 option "Enable a high-security level ".
     
     Versions 23 and later
     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.
     New in version 23
     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.
     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.

Versions 24 and later
Remark: Advanced Encryption Standard (128-bit AES algorithm with OFB):

• If the data file is encrypted using the AES algorithm, it is necessary to use the same method to encrypt the memos and indexes.
• If there is encryption that uses the AES algorithm, the option "Enable a high-security level " is automatically applied.

New in version 24
Remark: Advanced Encryption Standard (128-bit AES algorithm with OFB):

• If the data file is encrypted using the AES algorithm, it is necessary to use the same method to encrypt the memos and indexes.
• If there is encryption that uses the AES algorithm, the option "Enable a high-security level " is automatically applied.

Remark: Advanced Encryption Standard (128-bit AES algorithm with OFB):

• If the data file is encrypted using the AES algorithm, it is necessary to use the same method to encrypt the memos and indexes.
• If there is encryption that uses the AES algorithm, the option "Enable a high-security level " is automatically applied.