|
|
|
|
|
|
|
|
|
|
- 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 Access Connector Oracle, SQL Server, AS/400 or other native connectors.
An additional module is required for each type of Native Connector. Contact the sales team 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
Parameter <Type de la base>: "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 | | 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, ... | | ODBC via the OLE DB provider | OLE DB provider | | SQL functions | HFSQL functions (HReadxxx, ...) | SQL functions | HFSQL functions (HReadxxx, ...) | | Database connection | SQLConnect
Parameter <Type de la base>: "ODBC
Parameter <Provider OLEDB>: "MSSASQL" or hODBC constant. | HOpenConnection with the name of the connection to open. The connection must be defined in the analysis or dynamically (see below) | SQLConnect
Parameter <Type de la base>: "OLEDB
Parameter <Provider OLEDB>: corresponds to the desired parameter (string or 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 | | All the standard read functions:
HReadFirst, HReadNext, HReadSeek, ...
Filters | | 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 team regarding the availability for your database. (**): Speed indications are generic indications, the actual speed depends on the application, the configuration, the database content...
Esta página también está disponible para…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|