- 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, 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:
- Open the data model editor.
- On the "Analysis" tab, in the "Connection" group, click "Connections".
- 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, ...).
- 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,...
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
variable is used to describe one or more connections to external databases (HFSQL Client/Server, Native Connector, etc.).
This page is also available for…