PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
WINDEV, WEBDEV and WINDEV Mobile propose different methods for describing a connection:
Versions 17 and later
iPhone/iPad This feature is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This feature is now available for the iPhone/iPad applications.
iPhone/iPad This feature is now available for the iPhone/iPad applications.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Describing a connection in the data model editor

To describe a connection in the data model editor:

  1. Open the data model editor.
  2. Select "Analysis .. Connections". If no connection is defined in the data model editor, the wizard for creating a connection starts.On the "Analysis" pane, in the "Connection" group, click "Connections".
  3. In the wizard for connection creation, specify:
    • The type of connection to create (HyperFileSQL Client/Server or external database), 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,...
HDescribeConnection, HChangeConnection, ... 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. All you have to do is describe a temporary connection to a HFSQL Classic database and associate it with the file description found 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 Access, ...).
The connection can be established by HOpenConnection.
The Connection variable can also be used to:
Minimum required version
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment