PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

  • Overview
  • Adding a new file
  • Creating a new file
  • Importing a preset description of data file
  • Color for the descriptions of data files
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 the 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 file

Creating a new file

To create a new file:
  1. Select "Insert .. File". The wizard for creating a data file is started.Select "Insert .. Data file". The wizard for creating a data file is started.On the "Analysis" pane, in the "Creation" group, click "New file". The wizard for creating a data file is started.
  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 a data file". Go to the next step.
  3. Specify:
    • the logical name of the file. This name will be used to handle the data file.
    • the caption that briefly describes the subject of the data file.
    • the representation of a record in the data file. This representation improves the meaning of the questions asked when describing the 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 the 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 the 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 items of the data file.Then, specify:
    • whether the size of the data file can exceed 2 GB. This option can only be used if both the file system of the current computer and the system file of the 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 items of the data file.

Importing a preset description of data file

To import a preset description of a 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 is started.
  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 items of the data file 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.
Minimum required version
  • 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
May 23 2017