PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • 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. For more details, see Handling an external database.
  • from the data model editor: on the "Analysis" tab, in the "Connection" group, click "Connections".
Remark: 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. On the "Analysis" tab, in the "Connection" group, click "New connection".
  2. In the connection creation wizard, select the type of connection you want to create:
    • HFSQLDrive (paid solution).
    • PCSCloud (paid solution).
    • HFSQL Client/Server.
    • HFSQL Classic.
    • an external database.
  3. When creating a connection for HFSQLDrive, specify the characteristics of your HFSQLDrive database in the different steps of the wizard (for more details on HFDSQLDrive, see HFSQLDrive, your database in the Cloud in 3 clicks):
    • the server name or IP address
    • the server port number.
    • the user name and password.
    • the database name.
    • the connection name.
  4. When creating a connection for PCSCloud, specify the characteristics of your PCSCloud account in the different steps of the wizard (for more details on PCSCloud, see Cloud for HFSQL databases):
    • the server name or IP address
    • the server port number.
    • the user name and password.
    • the database name.
    • the connection name.
  1. When creating a connection for HFSQL Client/Server, specify the following in the different steps of the wizard:
    • the server name or IP address
    • the server port number.
    • the user name and password.
    • the database name.
    • the connection name.
  2. When creating a connection for HFSQL Classic, specify the following in the different steps of the wizard:
    • the connection name.
    • the default directory of data files.
  3. When creating a connection to an external database, specify the following in the different steps of the wizard:
    • 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 HFSQL Classic data files makes it easier to switch between connections. To use an HFSQL Client/Server database or an Oracle database for example, simply change the connection defined in the analysis (with HChangeConnection for example).
  • Using an HFSQL Classic connection is recommended when using the assisted universal replication
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment