ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / Editors / Data model editor / Logical Data Model
  • Overview
  • Creating an analysis (LDM)
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Overview
A Logical Data Model (LDM) describes the data structures (data files, fields, etc.) used in a WINDEV, WEBDEV or WINDEV Mobile application. This Logical Data Model is called an "Analysis" in WINDEV, WEBDEV or WINDEV Mobile, and can be created and edited via the data model editor.
Remarks:
  • The terms "MLD" and "Analyse" are used interchangeably to define the database structure associated with a project.
  • For details of how to manipulate an analysis (MLD), see Handling an analysis (MLD).
Creating an analysis (LDM)
To create an analysis (LDM):
  1. Click in the quick access buttons.
    • In the window that 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, etc.
      Note: If the analysis is to handle an external database, the corresponding native connector must be installed on the workstation.
  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. Confirm. The created analysis becomes the current analysis.
  6. Create all the elements of the analysis (data files, items and links).
    Note For more details, see Analysis data files, Items of a data file and Analysis links.
  7. To use the analysis in your project, generate the analysis: under the "Analysis" pane, in the "Analysis" group, pull down "Generation" and select "Generate". For more details, see Generating an analysis.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 12/07/2024

Send a report | Local help