ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

How to create and run an SQL query through programming?
This help page explains how to create and run an SQL query through programming.
Report based on an SQL query with data accessed via a connection (ODBC, etc.)
A report based on an SQL query with data accessed via a connection can print records from a database accessible via a specific ODBC driver or via a Native Connector...
HSuggestKeyEnd (Function)
Finishes collecting information on executed queries.
<Source>.ExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
Native MySQL Connector: Specific features
The Native MySQL Connector (also called "Native MySQL Access") creates "InnoDB" tables to support locks and transactions on a MySQL database......
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.)....
Native MariaDB Connector: Specific features
The Native MariaDB Connector creates "InnoDB" tables to support locks and transactions on a MariaDB database......
Setup of the WEBDEV Application Server for Linux
The installation package (or DVD, if provided) allows you to install...
Creating a report
The report editor allows you to easily create all types of reports via a wizard......
<Source>.MergeView (Function)
Creates an HFSQL view from two previously created views (HCreateView). This function uses the former view mechanism.
Setup of the WEBDEV Application Server for Linux
Utilisation dans la classe _edthymlStylePolice - Accès en Lecture + Ecriture - Type : Tous types
HCross (Function)
Crosses a record in a data file.
SourceName (Property)
The SourceName property is used to: Get the name of the report data source. Change the report data source....
Creating nested reports
HReadFirst (Function)
Sets the position on the first record according to a browse item.
HDeleteView (Function)
Deletes a previously created view. This function uses the former view mechanism.
NullSupported (Property)
The NullSupported property is used to manage the NULL value in HFSQL data files.
DisplayedItem (Property)
The DisplayedItem property is used to: Find out the item or the variable displayed by the control. Modify the item or the variable displayed by the control....
HViewToFile (Function)
Saves the modifications performed in an HFSQL view (by HModify, HDelete or HCross) in the corresponding data file. This function uses the former view mechanism.
Specific features of the Express version
HFSQL in network mode on a server running Windows NT4, 2000, XP or 2003
The access speed to the data in network depends on several parameters (see the section......
ParallelTaskExecute (Function)
Triggers the execution of a parallel task.
Native Informix Connector: Specific features and remarks
Remarks and specific features of Native Informix Connector...
HCreateView (Function)
Creates an HFSQL view. This function uses the former view mechanism....
Creating a Pivot Table control
To create a Pivot Table control......
Compile (Function)
Dynamically compiles an Procedure whose source code is provided (dynamic compilation).
HLockRecNum (Function)
Locks a record and restricts the access to this record for all the other applications.
HTransactionRollbackToSavepoint (Function)
Rolls the transaction back to the savepoint.
DescribedName (Property)
The DescribedName property is used to handle the logical name of HFSQL data files (ignoring possible changes made by HAlias).