ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL
  • Overview
  • Describing a connection in the data model editor
  • To describe a connection in the data model editor:
  • Describing a connection with HDescribeConnection,...
  • Describing a connection via the Connection type and via its properties
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Overview
WINDEV, WEBDEV and WINDEV Mobile propose different methods for describing a connection:
Describing a connection in the data model editor

To describe a connection in the data model editor:

  1. Open the data model editor.
  2. On the "Analysis" tab, in the "Connection" group, click "Connections".
  3. In the wizard for connection creation, specify:
    • The type of connection to create (HFSQL Client/Server or external database),
    • The characteristics of the connection (port, database, user, password, ...).
  4. If a connection was already described in the analysis, the list of connections as well as their characteristics displays (this list can be modified and tested).
Describing a connection with HDescribeConnection,...
The HDescribeConnection and HChangeConnection functions, ... allow you to describe a connection and to use it. The principle is as follows:
  • HDescribeConnection describes a new connection to an external database. This connection is named. Specific parameters can be defined such as the management mode of cursors (if the accessed database allows it).
  • To associate this connection with a table or with a file, use HChangeConnection.
  • To open the connection, use HOpenConnection. If the parameters of the connection described by HDescribeConnection are incorrect, HOpenConnection will return an error.
  • With HDescribeConnection, an Oracle table description imported into the analysis can be directly used by HFSQL Classic data files. Simply describe a temporary connection to an HFSQL Classic database and associate it with the file description from in the analysis.
Describing a connection via the Connection type and via its properties
A Connection variable is used to describe one or more connections to external databases (HFSQL Client/Server, Native Connector, etc.).
The connection can be established by HOpenConnection.
The Connection variable can also be used to:
Minimum version required
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/13/2023

Send a report | Local help