• 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. Select "Insert .. File". The wizard for creating a data file starts.Select "Insert .. Data file". The wizard for creating a data file starts.On the "Analysis" pane, in the "Creation" group, click "New file". The wizard for creating a data file starts.
2. Check "Create a new file description". Go to the next step. Check "Create a new description of data file". Go to the next step. 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 access used for the data file. Depending on the selected type, this data file will be handled by the HyperFileSQL engine, by an OLE DB driver or by one of the native accesses (SQL Server, Oracle, ...).
   If the type of access used differs from HyperFileSQL Classic (network or single-user), you must specify the characteristics of the connection to the database.In the next step, specify the type of database associated with the data file. Depending on the selected type, this data file will be handled by the HFSQL engine, by an OLE DB driver or by one of native accesses (SQL Server, Oracle, ...).
   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 description window of file items is automatically opened. It allows you to describe the file items.Then, specify:
   • whether the size of data file can exceed 2 GB. This option can only be used if both the file system of current computer and the system file of computers where the application will be deployed support the NTSF format (Windows 2000, NT or XP).
     Caution: If this option is checked, this data file cannot be opened in Windows 98 or Me.
   • whether the data file must support the replication. This option is used to manage the automatic updates of identical and remote databases. See replication for more details.
     The created data file becomes the current data file. The description window of file items is automatically opened. It allows you to describe the file items.

Importing a preset description of data file

1. Select "Insert .. File".Select "Insert .. Data file".On the "Analysis" pane, in the "Creation" group, click "New file". The wizard for creating a data file starts.
2. Check the "Select a description among the preset files" option.Check the "Select a description among the preset data files" option.Select the option "Select a description among the preset data files".
3. Choose the preset data file. This data file will be imported into the current analysis. This data file can be modified later.Choose the preset data file(s) to create.
   
   At the bottom of the screen, the wizard proposes the associated data files that can be added.
4. Select the file items to store. These items can be modified later.For each data file, select the items to keep. These items can be modified later.
5. Specify whether the links must be automatically sought. If this option is checked, the items with the same name will be linked.
   The preset data file is automatically inserted into the current analysis.The preset data files are automatically inserted into the current analysis. The links are automatically implemented between the preset files.

• Blue for the data files coming from a Native Access.
• Orange for the HFSQL Client/Server data files.
• Brown for the HFSQL Classic data files.
• Green for the ODBC data files.
• Gray for the Hyper File 5.5 data files.

1. Display 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.
     
     
     
     Versions 23 and later
     The option "Automatic encryption if password (16-round RC5)" is selected by default when creating a data file. This option is used to automatically encrypt the file if a password is defined by HPass on the data file.
     New in version 23
     The option "Automatic encryption if password (16-round RC5)" is selected by default when creating a data file. This option is used to automatically encrypt the file if a password is defined by HPass on the data file.
     The option "Automatic encryption if password (16-round RC5)" is selected by default when creating a data file. This option is used to automatically encrypt the file if a password is defined by HPass on the data file. The option "Automatic (16-round RCS if password)" is selected by default when creating a data file. This option is used to automatically encrypt the data file if a password is defined by HPass on the data file.
   • Enable the "Reinforced security" option. This option allows you to ask for the password at each automatic modification of data file. Enable the option "Enable a high-security level ".
     
     Versions 23 and later
     Note: This option is selected by default when creating a data file. This option allows you to ask for the password at each automatic modification of data file.
     New in version 23
     Note: This option is selected by default when creating a data file. This option allows you to ask for the password at each automatic modification of data file.
     Note: This option is selected by default when creating a data file. This option allows you to ask for the password at each automatic modification of data file.
3. Generate the analysis.
4. Specify a password for the data file with HPass.

Versions 24 and later
Note: 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
Note: 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.

Note: 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.