ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

HAlias (Function)
Creates a logical alias of a data file (or query) or cancels all existing aliases.
FileToArray (Function)
Fills an array of classes or structures with the content of an HFSQL data file or query.
HSuggestKey (Function)
Returns a list of keys to add to data files to improve query performance.
<Source>.ActivateFilter (Function)
Enables the filter that was previously created for the specified data file (view or query).
<Source>.Alias (Function)
Creates a logical alias of a data file (or query) or cancels all existing aliases.
sfProcessWorkItemRequest (Type of variable)
The sfProcessWorkItemRequest type is used to describe a query for processing a task to submit to SFExecuteProcess...
SQLInfo (Function)
Initializes the different SQL variables with information relative to the last query run.
HActivateFilter (Function)
Enables the filter that was previously created for the specified data file (view or query).
SQLFetch (Function)
Goes to the next row (i.e next record) of the query result.
SQLCodeExecuted (Property)
The SQLCodeExecuted property gets the SQL code of a query after replacing the parameters with a value.
User report editor (Reports & Queries)
A report provides a custom view of data......
ImageType (Property)
The ImageType property is used to get the type of image being edited in an Image Editor control (icon or image).
Diagram (Type of variable)
The Diagram type is used to define all the advanced characteristics of a diagram that can be edited in the Diagram Editor control.
Alias type
The Alias type is used to declare and handle a logical alias for a data file or query.
Sort order of records found in a select query
To make the result of a query easier to read, the records can be sorted according to one or more items......
<Source>.ListKey (Function)
Returns the list of keys found in a file (query or view) recognized by the HFSQL engine.
<Source>.Modify (Function)
Modifies the specified record or the record found in memory in the data file (query or view).
<Source>.RetrieveItem (Function)
Returns the content of an item found in the current record (in the data file, view, query, ...).
IWListDisplay (Function)
Refreshes the display of an "Internal window" control with automatic iteration on a data file or query.
SQLGetTextMemo (Function)
Retrieves the content of a Text Memo column found in the query result, for the current line.
HRetrieveItem (Function)
Returns the content of an item found in the current record (in the data file, view, query, ...).
HListKey (Function)
Returns the list of keys found in a file (query or view) recognized by the HFSQL engine.
HModify (Function)
Modifies the specified record or the record found in memory in the data file (query or view).
Looper control linked to a data file
A Looper control can be used to display the content of a data file or query......
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, ......