PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Creating a connection
  • Creating a connection (Data model editor)
  • Benefit of HFSQL Classic connections
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
Data model editor: Describing a connection
Overview
Any program developed with WINDEV, WEBDEV or WINDEV Mobile can easily access:
  • a HFSQL database.
  • a database other than HFSQL.
In any case, all you have to do is describe the structure of the database in the analysis.
The connections are used to link the description of a data file with the real data. For example, a connection is automatically created when a file belonging to an external database is imported into the data model editor.
The connections are created:
  • when importing a data file that belongs to an existing database. See Handling an external database for more details.
  • from the data model editor, via "Analysis .. Connections" in the data model editor.from the data model editor: on the "Analysis" pane, in the "Connection" group, click "Connections".
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Creating a connection

Creating a connection (Data model editor)

To create a connection in the data model editor:
  1. Select "Analysis .. Connections".
    • If connections are already available, the list of existing connections is displayed. Click "+" to create a new connection.
    • If no connection is available, the wizard for creating a connection starts automatically.
    On the "Analysis" pane, in the "Connection" group, click "New connection".
  2. In the wizard for connection creation, select the type of connection to create:
    • HyperFileSQL Client/Server.HFSQL Client/Server.
    • HyperFileSQL Classic.HFSQL Classic.
    • an external database.
  3. When creating a connection for HyperFileSQL Client/Server, specify in the different wizard planes:When creating a connection for HFSQL Client/Server, specify in the different wizard planes:
    • the name or IP address of the server
    • the port number of the server.
    • the user name and the password.
    • the name of the database.
    • the name of the connection.
  4. When creating a connection for HyperFileSQL Classic, specify in the different wizard planes:When creating a connection for HFSQL Classic, specify in the different wizard planes:
    • the name of the connection.
    • the default directory of data files.
  5. When creating a connection to an external database, specify in the different wizard planes:
    • the type of access used for the connection
    • the name or IP address of the server or the path of the file.
    • the user name and the password.
    • the name of the database.
    • the name of the connection.
Once created, the connection can be associated with a data file in the description window of the file.
Benefit of HFSQL Classic connections
  • Using a connection for the HFSQL Classic files simplifies the operations for changing connection. To use a HFSQL Client/Server database or an Oracle database for example, all you have to do is change the connection defined in the analysis (by using HChangeConnection for example).
  • Using a HFSQL Classic connection is recommended when using the assisted universal replication.
Minimum required version
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment