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...
HExportXML (Function)
Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file.
<Source>.ExportXML (Function)
Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file.
AS/400: Development method
The Native AS/400 Connector simplifies access to AS/400 data from your WINDEV and WEBDEV applications......
Distributing Reports & Queries
This help page presents the operations that must be performed in order for a WINDEV application to be handled by Reports & Queries......
Deserialize (Function)
Deserializes a buffer or a character string containing the data from a class, structure, array (including an associative array), queue, stack, list or advanced variable, as well as their subelements.
HListFullTextIndex (Function)
Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine.
HDuplicateRecord (Function)
Duplicates the record read in a data file: the record found in memory is added into the data file (query or view).
<Source>.DuplicateRecord (Function)
Duplicates the record read in a data file: the record found in memory is added into the data file (query or view).
<Source>.Out (Function)
Allows you to find out whether the record on which you want to be positioned is located outside the data file, filter, view or query.
<Source>.ExtractMemo (Function)
Extracts the content of a binary memo item from an HFSQL file, a query or an HFSQL view to a physical file (on disk).
<Source>.ListFullTextIndex (Function)
Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine.
FilterCondition (Property)
The FilterCondition property allows you to know the selection condition set by HFilter on a data file, HFSQL view or query.
HOut (Function)
Used to find out whether the record on which you want to be positioned is located outside the data file, filter, view or query.
HExtractMemo (Function)
Extracts the content of a binary memo item from an HFSQL file, a query or an HFSQL view to a physical file (on disk).
ExecutionCompleted (Property)
The ExecutionCompleted property is used to determine whether the execution of a query or view (HFSQL Classic or Client/Server) is completed....
HTTPProgressBar (Function)
Displays a progress bar when: receiving the response to an HTTP request. sending an HTTP form (HTTPSendForm) or an HTTP query....
HNbRec (Function)
Returns the number of records in a file, query or HFSQL view: active records, crossed records, deleted records, etc.
<Source>.NbRec (Function)
Returns the number of records in a file, query or HFSQL view: active records, crossed records, deleted records, etc.
FilterWithBounds (Property)
The FilterWithBounds property is used to determine if bounds have been specified for the filter implemented by HFilter on an HFSQL data file, view or query.
HFileExist (Function)
Determines: whether a file exists, which means whether it was physically created (HCreation or HCreationIfNotFound). whether a view or a query was defined....
<Source>.FileExist (Function)
Determines: whether a file exists, which means whether it was physically created (HCreation or HCreationIfNotFound). whether a view or a query was defined....
fReportsAndQueriesDir (Function)
Returns: the full path of the directory for the custom reports and queries. This directory corresponds to the directory of the reports and queries visible by the user who created them. the full path of the directory for the shared reports and queries. This directory corresponds to the directory of the reports and queries visible by all the application users....
MySource (Reserved word)
MySource is used to handle the current data source (file, view or query) associated with a report or with a table based on a data file...
HToFile (Function)
Copies a data source (file, query, view, ...) to a physical HFSQL file with the same description. This file is neither encrypted nor password protected.
<Source>.ToFile (Function)
Copies a data source (file, query, view, ...) to a physical HFSQL file with the same description. This file is neither encrypted nor password protected.