ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

OLE DB: System requirements
To handle a database via OLE DB, the following elements must be installed on the development computer and on the deployment computer...
Examples for using the OLE DB provider for HFSQL
Reinitializes the content of an Organization Chart control from its data source (HFSQL data file for example).
OLE DB provider for HFSQL
The OLE DB provider on HFSQL is used to access an HFSQL database (Classic or Client/Server) from an external software that manages the accesses by OLE DB...
SQLConnectWS (Function)
Connects the current application to a database that will be queried by SQL through a web service proxy (SOAP).
Database access: summary
WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed....
SQLConnect (Function)
Connects the current application to a database that must be interrogated via SQL.
HDescribeConnection (Function)
Describes a new connection to an external database.
Optional connection information
When defining the connections in the data model editor or when defining the connections programmatically, you have the ability to specifier the optional connection information...
HListProvider (Function)
Returns the list of OLE DB providers and/or Native Connectors installed on the current computer.
HForward (Function)
Moves several records forward from the current position in the data file, according to a specified item.
HOnError (Function)
Customizes the management of HFSQL errors.
HTransaction (Function)
Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates the transaction file.
HWrite (Function)
Writes a record into a table without updating the indexes corresponding to all keys used in the table.
HTransactionCancel (Function)
If a transaction is in progress, rolls back all operations performed on tables in transactions since the start of the transaction.
HReadSeekLast (Function)
Sets the position on the last record whose value for a specific item is less than or equal to a sought value (exact-match search).
SQLLock (Function)
Used to lock: The entire data table, in read and write mode. Its data cannot be accessed by other computers. The records selected by the query. This data cannot be accessed by the other computers. This method can be used to update records for example....
HListLink (Function)
Returns the list of links (Merise) in the current analysis or in a specific analysis
HListTrigger (Function)
Returns the list of triggers applied to one or more HFSQL data files.
HError (Function)
Returns the number of the last error triggered by the HFSQL engine.
Filters in Table controls based on a data file
WINDEV, WEBDEV and WINDEV Mobile include multiple methods to filter the records displayed in a Table control based on a data file......
HTransactionStart (Function)
Starts a transaction on the tables (HFSQL or accessed via a Native Connector) and creates the transaction table.
WDInst: installing additional elements
By default, only the files found in the "List of setup files" window are installed on the user computers......
CacheSize (Property)
The CacheSize property is used to: Get the maximum number of records that can be stored in the cache of the Native MySQL Connector. Change the maximum number of records that can be stored in the cache of the Native MySQL Connector....
SQLGetCol (Function)
Retrieves the content of the specified column from the query result, for the current line.