Database access: summary

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL

Overview
Specific features
Which function to use?
HFSQL access

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HFSQL functions

Database access: summary

Overview

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.

Specific features

xBase access possible via HFSQL
Specific xBase functions can be used in addition to the standard HFSQL functions (HDBOpen, etc.).

ASCII files
Use WLanguage functions specific to external files (fOpen, fRead, fWrite, etc.).

INI files
Use WLanguage functions specific to INI files (INIRead, INIWrite, etc.).

Managing the registry
Use WLanguage functions specific to the registry (RegistryQueryValue, RegistrySetValue, etc.).

Which function to use?

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: HOpenAnalysis HDeclareExternal HDeclare
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: HReadFirst, HReadNext, HReadSeek, ... Filters Views
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: HCloseAnalysis, HCancelDeclaration
Speed (**) General case	*()	***


	ORACLE, SQL Server, Access, ...
	*Native Connector/Access ()**		ODBC driver (Direct)
	SQL functions	HFSQL functions (HReadxxx, ...)	SQL functions
Database connection	SQLConnect Parameter <Type de la base>: "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 Parameter <Type de la base>: "ODBC
Dynamic description of the connection		HDescribeConnection	SQLConnect Parameter <Type de la base>: "ODBC
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 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	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 team regarding the availability for your database.

(**): Speed indications are generic indications, the actual speed depends on the application, the configuration, the database content...