ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

CursorOptions (Property)
The CursorOptions property is used to manage the type of cursor used for a connection (Native Connectors, OLE DB, etc.).
SQLTransaction (Function)
Begins, commits or rolls back a transaction: on the files of a database opened by SQLConnect, on the files of a database opened by a connection (OLE DB or Native Access/Native Connector) described in the data model editor or by HOpenConnection....
HConnect (Function)
Redefines one or more connection parameters via Native Connector (Access, SQL Server, MySQL or Oracle) or via an OLE DB access on a specific table or set of tables.
Access (Property)
The Access property is used to manage the type of access of a connection (HFSQL Client/Server, OLE DB, etc.)....
Database (Property)
The Database property is used to manage databases associated with a connection (HFSQL Client/Server, OLE DB, etc.)....
HListProvider (Function)
Returns the list of OLE DB providers and/or Native Connectors installed on the current computer....
NULL values in HFSQL
WINDEV, WEBDEV and WINDEV Mobile allow you to manage the NULL value in the items of HFSQL data files and for all the other types of accesses (Native, OLE DB, ......
Provider (Property)
The Provider property is used to manage the type of a connection (HFSQL Client/Server, OLE DB, etc.)....
Source (Property)
The Source property can be used on: a Chart control: in this case, the Source property is used to get the source of the series: Table column, list of values, ... a connection: in this case, the Source property is used to get or set the source of a connection (HFSQL Client/Server, OLE DB, etc.)....
Server (Property)
The Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.)....
User (Property)
The User property is used to manage the user of a connection (HFSQL Client/Server, OLE DB, etc.)....
SysReleaseDC (Function)
Frees the current DC (Device Context) retrieved by SysGetDC.
HExportJSONString (Function)
Exports the records from a data file (HFSQL or OLE DB), view or query to a JSON string.
<HFSQL file>.ExportJSONString (Function)
Exports the records from a data file (HFSQL or OLE DB), view or query to a JSON string.
<Source>.ExportXML (Function)
Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file.
HExportXML (Function)
Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file.
Modifying the query content
The queries are used to easily select the records coming from one or more files, matching one or more selection criteria, ......
<Source>.ExportCSV (Function)
Exports the records found in a table (HFSQL or OLE DB), a view or a query to a CSV file.
CtDescribedOLEDBProvider (Property)
The CtDescribedOLEDBProvider property gets and sets the name of the OLE DB provider (also called OLE DB server).
CtDescribedUserName (Property)
The CtDescribedUserName property sets the username used to connect to a specific table via OLE DB.
SQL commands available in an SQL query
WINDEV allows you to easily run queries in SQL code......
CtDescribedAccess (Property)
The CtDescribedAccess property is used to set the type of access to the table when connecting to a specific table via OLE DB.
<Source>.ExportXLS (Function)
Exports records from a table (HFSQL or OLE DB), view or query to an Excel file (XLSX).