ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

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...
Overloading a WLanguage function or using a WLanguage function in an SQL query
WLanguage includes the "WL" keyword...
HSuggestKeyEnd (Function)
Finishes collecting information on executed queries.
SQL functions for accessing the external databases
List of SQL functions used to access the external databases
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
HSuggestKeyStart (Function)
Starts collecting information on executed queries.
Cross-database queries
An SQL query can operate on different databases...
HExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
<Source>.ExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
HSuggestKey (Function)
Returns a list of keys to add to data files to improve query performance.
<Source>.ExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
Creating a query in SQL code
The query editor allows you to create a query by typing SQL code...
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......
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
The installation package (or DVD, if provided) allows you to install...
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....
ParallelTaskExecute (Function)
Triggers the execution of a parallel task.
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......
Creating nested reports
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).