PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • Overview
  • Creating an LDM
  • Optimizing the analysis
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
A Logical Data Model (LDM) allows you to describe the data structures (data files, items, ...) used in a WINDEV, WEBDEV or WINDEV Mobile application.
Remarks:
  • The "LDM" and "Analysis" terms are indifferently used to define the structure of database associated with a project.
  • See Handling an LDM for more details.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Creating an LDM
To create an LDM:
  1. Click in the quick access buttons.
    • The element creation window appears: click "Data" then "Analysis".
    • The analysis creation wizard starts.
  2. In the first step of the wizard, indicate:
    • the analysis name and directory. The analysis corresponds to a ".WDA" file. By default, this file will be created in the directory of the project analysis (<Project name>.ANA directory). This directory must be accessible in read/write mode.
    • whether the analysis must be associated with the current project instead of the current analysis (when creating an analysis in a project already associated with an analysis).
    • the analysis description that briefly describes the subject of the analysis.
  3. The next step of wizard is to specify the type of database the project will use:
    • HFSQLDrive (paid solution). For more details on HFSQLDrive, see HFSQLDrive, your database in the Cloud in 3 clicks.
    • PCSCloud (paid solution). For more details on PCSCloud, see Cloud for HFSQL databases.
    • HFSQL Client/Server,
    • HFSQL Classic,
    • External databases: SQL Server, Oracle, MySQL, ...
      Remark: If the analysis must handle an external database, the corresponding native access must be installed on the computer.
  4. For any database other than HFSQL Classic, the wizard allows you to define the connection to the database (name, caption) and specify advanced settings (server, user and password). This information can be edited later in the data model editor.
  5. Validate. The created analysis becomes the current analysis.
  6. Create all the elements (data files, items and links) of your analysis.
    Remark: For more details, see Data files of analysis, Items of a data file and Analysis links.
  7. To use the analysis in your project, generate the analysis: on the "Analysis" tab, in the "Analysis" group, expand "Generation" and select "Generation". For more details, see Generating an analysis.
Versions 20 and later

Optimizing the analysis

From version 20, the format for storing the analysis is optimized. Any new analysis created with version 20 (or later) uses this new format.
You have the ability to save the existing analyses with this new format.
Caution: An analysis that uses this new format will not be compatible with versions earlier than version 19.
To use the new format on your existing analyses:
  1. Open the analysis description window ("Analysis description" in the popup menu of the analysis chart).
  2. In the "Details" tab, click "Save the analysis in a more compact format".
New in version 20

Optimizing the analysis

From version 20, the format for storing the analysis is optimized. Any new analysis created with version 20 (or later) uses this new format.
You have the ability to save the existing analyses with this new format.
Caution: An analysis that uses this new format will not be compatible with versions earlier than version 19.
To use the new format on your existing analyses:
  1. Open the analysis description window ("Analysis description" in the popup menu of the analysis chart).
  2. In the "Details" tab, click "Save the analysis in a more compact format".

Optimizing the analysis

From version 20, the format for storing the analysis is optimized. Any new analysis created with version 20 (or later) uses this new format.
You have the ability to save the existing analyses with this new format.
Caution: An analysis that uses this new format will not be compatible with versions earlier than version 19.
To use the new format on your existing analyses:
  1. Open the analysis description window ("Analysis description" in the popup menu of the analysis chart).
  2. In the "Details" tab, click "Save the analysis in a more compact format".
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment