PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | French EN
  • 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/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:
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:
    • "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.
See Operations on a data file and Operations on an item for more details. Remark: 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. 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 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. 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.
    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.
    • 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.
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