|
|
|
|
|
|
|
|
|
|
- Overview
- Specific features
- Which function to use?
- HFSQL access
WINDEV, WEBDEV and WINDEV Mobile support different SQL query execution modes depending on how the database was accessed. - Access to an HFSQL database (can be freely distributed with your WINDEV applications):
No setup constraint.
The SQL and HFSQL functions (HReadxxx, ...) can be used with this type of access. - Access via a Native Connector (native access): Native Oracle, SQL Server, AS/400 Connector.
An additional module is required for each type of Native Connector. Contact the sales department regarding the availability for your database.
For the Oracle or SQL Server accesses, a client library must be installed on the user computer.
The SQL and HFSQL functions (HReadxxx, ...) can be used with this type of access. This type of access is faster than the accesses by ODBC or via an OLE DB provider. - Access via a direct OLE DB driver:
The characteristics of the connection to the database must be defined in the ODBC administrator of Windows. Only the SQL functions can be used for this type of access. The HFSQL functions (HReadxxx, ...) cannot be used. - ODBC access via the OLE DB provider:
This type of access uses a specific OLE DB provider. This type of access is not recommended because it is slower than an access via an ODBC driver. Indeed, the performance is not as good as with a direct ODBC driver because the access is performed both via the ODBC driver and the OLE DB provider.
The HFSQL (HReadxxx, ...) and SQL functions can be used with this type of access.
The characteristics of the connection to the database must be defined in the ODBC administrator of Windows. The provider as well as MDAC 2.6 (or later) must be installed on the computer. - Access via an OLE DB provider:
This type of access uses an OLE DB provider. The provider as well as MDAC 2.6 (or later) must be installed on the computer.
The SQL and HFSQL functions (HReadxxx, ...) can be used with this type of access.
xBase access possible via HFSQLSpecific xBase functions can be used in addition to the standard HFSQL functions ( HDBOpen, etc.). ASCII filesUse WLanguage functions specific to external files ( fOpen, fRead, fWrite, etc.). INI filesUse WLanguage functions specific to INI files ( INIRead, INIWrite, etc.). HFSQL access | | | | HFSQL |
|---|
| Embedded access | | SQL functions | HFSQL functions (HReadxxx, ...) | | Database connection | SQLConnect
<Database Type> parameter: "HFSQL" | If the analysis is linked to the project, automatic connection, otherwise, use one of the following functions: | | Dynamic description of the connection | Not used | Not used | | Query execution | SQLExec | HExecuteQuery, HExecuteSQLQuery | | Read the result | - SQLFirst/SQLCol browse
- SQLFetch/SQLGetCol, SQLGetMemo browse
- SQLTable | All the standard read functions: | | Lock records | Not possible | HLockFile
HLockRecNum
Locking read functions (HReadFirst, HReadSeek, ...) | | Switch to another open connection | SQLChangeConnection | Not used | | Close connection | SQLDisconnect | If the analysis is linked to the project, automatic closing ; otherwise, use one of the following functions: | Speed (**)
General case | **(*) | *** |
| | | | | ORACLE, SQL Server, Access, ... | | Native Connector/Access (*) | ODBC driver (Direct) | | SQL functions | HFSQL functions (HReadxxx, ...) | SQL functions | | Database connection | SQLConnect
<Database Type> parameter: "ORACLE" or "SQL SERVER" or "AS400" | HOpenConnection with the name of the connection to open. The connection must be defined in the analysis or dynamically (see below) | SQLConnect
<Database Type> parameter: "ODBC" | | Dynamic description of the connection | HDescribeConnection | | Query execution | SQLExec | HExecuteQuery, HExecuteSQLQuery | SQLExec | | Read the result | - SQLFirst/SQLCol browse
- SQLFetch/SQLGetCol, SQLGetMemo browse
- SQLTable | All the standard read functions:
HReadFirst, HReadNext, HReadSeek, ...
Filters | - SQLFirst/SQLCol browse
- SQLFetch/SQLGetCol, SQLGetMemo browse
- SQLTable | | Lock records | SQLLock | Each database includes specific features. For the native SQL Server or Oracle access, ability to use HLockFile. | The locks are not supported by the ODBC driver. | | Switch to another open connection | SQLChangeConnection | The connection used is specified in HExecuteSQLQuery or in HExecuteQuery. | SQLChangeConnection | | Close connection | SQLDisconnect | HCloseConnection | SQLDisconnect | Speed (**)
General case | *** | **(*) | ** |
| | | | | | ORACLE, SQL Server, Access, ... | | ODBC via the OLE DB provider | OLE DB provider | | SQL functions | HFSQL functions (HReadxxx, ...) | SQL functions | HFSQL functions (HReadxxx, ...) | | Database connection | SQLConnect
<Database Type> parameter: "ODBC"
<OLEDB Provider> parameter: "MSSASQL" or the hODBC constant. | HOpenConnection with the name of the connection to open. The connection must be defined in the analysis or dynamically (see below) | SQLConnect
<Database Type> parameter: "OLEDB"
<OLEDB Provider> parameter: corresponding to the desired option (character string ot constant) | HOpenConnection with the name of the connection to open. The connection must be defined in the analysis or dynamically (see below). | | Dynamic description of the connection | HDescribeConnection | HDescribeConnection | | Query execution | | SQLExec | HExecuteQuery, HExecuteSQLQuery | HExecuteQuery, HExecuteSQLQuery | | Read the result | - SQLFirst/SQLCol browse
- SQLFetch/SQLGetCol, SQLGetMemo browse
- SQLTable | All the standard read functions:
HReadFirst, HReadNext, HReadSeek, ...
Filters | - SQLFirst/SQLCol browse
- SQLFetch/SQLGetCol, SQLGetMemo browse
- SQLTable | All the standard read functions:
HReadFirst, HReadNext, HReadSeek, ...
Filters | | Lock records | The locks are not supported by the provider. | The locks are not supported by the provider. | The locks are not supported by the provider. | The locks are not supported by the provider. | | Switch to another open connection | SQLChangeConnection | The connection used is specified in HExecuteSQLQuery or in HExecuteQuery. | SQLChangeConnection | The connection used is specified in HExecuteSQLQuery or in HExecuteQuery. | | Close connection | SQLDisconnect | HCloseConnection | SQLDisconnect | HCloseConnection | Speed (**)
General case | * | * | ** | * (*) |
(*): Contact the sales department regarding the availability for your database. (**): Speed indications are generic indications, the actual speed depends on the application, the configuration, the database content...
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|