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:
  • an HFSQL database.
  • a database other than HFSQL.
In any case, all you have to do is describe the database structure 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 server
    • the port number of server.
    • the user name and password.
    • the database name.
    • the connection name.
  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 connection name.
    • 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 server or the file path.
    • the user name and password.
    • the database name.
    • the connection name.
Once created, the connection can be associated with a data file in the description window of data file
Benefit of HFSQL Classic connections
  • Using a connection for the HFSQL Classic files simplifies the operations for changing connection. To use an 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 an 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