ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

<Source>.PrepareSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query.
Database access: summary
WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed....
<Source>.ExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
HPrepareSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query.
Importing tables into the database schema (external database, etc.)
WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc, ...
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
HFSQL management functions
List of functions for HFSQL management...
<Source>.ChangeConnection (Function)
Dynamically changes the connection associated with a table.
<Connection variable>.TransactionStart (Function)
Starts a transaction on the tables (HFSQL or accessed via Native Access) and creates the transaction table.
<Source>.SetTransaction (Function)
Enables or disables the management of transactions for one or more files.
<Source>.ChangeDir (Function)
Changes the path to a data file (i.e. directory in which the file will be handled).
HListHistoryReindexing (Function)
Lists the operations performed on current tables, over the last 24 hours, or on the last 1000 tables. These operations include reindexing, recalculation of statistics, memo verification, index verification, etc. This new function is available from WINDEV Suite SaaS 2025 - Update 2....
<Source>.TransactionFree (Function)
Transforms all "in transaction" records into "Normal" records if they do not belong to an ongoing transaction.
HInfoItemRights (Function)
Gets the rights granted to a user or group on an item.
HChangeConnection (Function)
Dynamically changes the connection associated with a data file.
HChangeDir (Function)
Changes the path to a data file (i.e. directory in which the file will be handled).
HTransactionFree (Function)
Transforms all "in transaction" records into "normal" records if they do not belong to a transaction currently in progress.
Transforming a WINDEV project into Mobile: a detailed audit
Transforming WINDEV applications into Mobile is very easy......
HExecuteQuery (Function)
Declares a query created in the query editor to the HFSQL engine and runs this query.
HSetTransaction (Function)
Enables or disables the management of transactions for one or more files.
Native Oracle Connector for WINDEV and WEBDEV
WINDEV and WEBDEV support an optional Native Oracle Connector (also called Native Oracle Access......
Characteristics of the columns of a Table control in a page
The columns are used to display information in a Table control....