PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Overview
  • Specific features
  • Which function to use?
  • HFSQL access
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
Accessing the databases: summary
Overview
WINDEV and WEBDEV propose different runtime modes of SQL queries according to the type of access to the database.
  • Access to a 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.
    For each type of Native Connector, you must own an additional WINDEV module. Contact the sales department regarding the availability for your database.
    For the Oracle or SQL Server accesses, a client layer 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 is using 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 is using 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.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Specific features
xBase access possible via HFSQL
Specific xBase functions can be used in addition to the standard HFSQL functions (HDBOpen, ...).
ASCII files
Use the WLanguage functions specific to external files (fOpen, fRead, fWrite, ...)
INI files
Use the WLanguage functions specific to the INI files (INIRead, INIWrite, ...)
Managing the registry
Use the WLanguage functions specific to the registry (RegistryQueryValue, RegistrySetValue, ...)
Which function to use?

HFSQL access

HFSQL
Embedded access
SQL functionsHFSQL functions (HReadxxx, ...)
Connecting to the databaseSQLConnect
<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 connectionUselessUseless
Running the querySQLExecHExecuteQuery, HExecuteSQLQuery
Reading the result- SQLFirst/SQLCol browse
- SQLFetch/SQLGetCol, SQLGetMemo browse
- SQLTable
All the standard read functions:
Locking recordsNot possibleHLockFile
HLockRecNum
Locking read functions (HReadFirst, HReadSeek, ...)
Changing the connection (switch to another opened connection)SQLChangeConnectionUseless
Closing the connectionSQLDisconnectIf 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 functionsHFSQL functions (HReadxxx, ...)SQL functions
Connecting to the databaseSQLConnect
<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 connectionHDescribeConnection
Running the querySQLExecHExecuteQuery, HExecuteSQLQuerySQLExec
Reading the result- SQLFirst/SQLCol browse
- SQLFetch/SQLGetCol, SQLGetMemo browse
- SQLTable
All the standard read functions:
HReadFirst, HReadNext, HReadSeek, ...
The filters
- SQLFirst/SQLCol browse
- SQLFetch/SQLGetCol, SQLGetMemo browse
- SQLTable
Locking recordsSQLLockEach 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.
Changing the connection (switch to another opened connection)SQLChangeConnectionThe connection used is specified in HExecuteSQLQuery or in HExecuteQuery.SQLChangeConnection
Closing the connectionSQLDisconnectHCloseConnectionSQLDisconnect
Speed (**)
General case
*****(*)**
ORACLE, SQL Server, Access, ...
ODBC via the OLE DB provider
OLE DB provider
SQL functionsHFSQL functions (HReadxxx, ...)SQL functionsHFSQL functions (HReadxxx, ...)
Connecting to the databaseSQLConnect
<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 requested one (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 connectionHDescribeConnectionHDescribeConnection
Running the querySQLExecHExecuteQuery, HExecuteSQLQueryHExecuteQuery, HExecuteSQLQuery
Reading the result- SQLFirst/SQLCol browse
- SQLFetch/SQLGetCol, SQLGetMemo browse
- SQLTable
All the standard read functions:
HReadFirst, HReadNext, HReadSeek, ...
The filters
- SQLFirst/SQLCol browse
- SQLFetch/SQLGetCol, SQLGetMemo browse
- SQLTable
All the standard read functions:
HReadFirst, HReadNext, HReadSeek, ...
The filters
Locking recordsThe 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.
Changing the connection (switch to another opened connection)SQLChangeConnectionThe connection used is specified in HExecuteSQLQuery or in HExecuteQuery.SQLChangeConnectionThe connection used is specified in HExecuteSQLQuery or in HExecuteQuery.
Closing the connectionSQLDisconnectHCloseConnectionSQLDisconnectHCloseConnection
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...
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment