PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • 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 a HFSQL 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
The analysis is used to define the structure of data files used by the project.
You can describe in the analysis:
Note: 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:
    • "Description of data file".
    • "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.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Adding a new data file

Creating a new data file

To create 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

To import a preset file description:
  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.
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 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.
Security of a HFSQL data file
To insure the security of a HFSQL data file:
  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.
Minimum version required
  • Version 9
This page is also available for…
Comments
Let's create an analysis for, cost center
boa noite

Aula 1157 WinDev Curso ErpAmarildo 15 - Analise Centro Custo Nivel


Nessa aula de hoje
Vamos criar uma analise para, de centro de custo
quero fazer niveis, e tambem , essa aula , servira
para fazer plano de contas.

In this class today
Let's create an analysis for, cost center
I want to make levels, and also, this class, will serve
To make chart of accounts.

En esta clase de hoy
Vamos a crear un análisis para, de centro de coste
Quiero hacer niveles, y también, esa clase, serviría
Para hacer plan de cuentas.

https://forum.pcsoft.fr/pt-BR/pcsoft.br.windev/2408-video-aulas-amarildo-aula-1157-windev-curso-erpamarildo/read.awp

https://doc.windev.com/en-US/?2011010

http://windevdesenvolvimento.blogspot.com.br/2017/05/aula-1157-windev-curso-erpamarildo-15.html

https://www.youtube.com/watch?v=mtZGoWl5TY0
De matos
23 May 2017