ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

HFSQL management functions (prefix syntax)
List of functions for HFSQL management...
Stored procedures and queries (HFSQL Client/Server)
The stored procedures are used to simplify the development and the maintenance of your applications by factorizing the code......
WDOptimizer: Overview
The different operations that can be performed with WDOptimizer are as follows......
21. Reports
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...
<Window>.ToFile (Function)
Automatically updates: the values of a data file's items in memory with the values from the controls in the window. The data file items bound to the window controls are automatically updated with the values of these controls. the value of the WLanguage variables with the value of the window controls. The WLanguage variables bound to the window controls are automatically updated with the values of these controls. This function is also available for WEBDEV pages....
HDBOpen (Function)
Opens the xBase data file and the "memo" file if it exists.
13. Print: Reports
WINDEV reports...
<Source>.Add (Function)
Add: the record found in memory into the data file (query or view). the record found in a Record variable into the data file (query or view)....
HAdd (Function)
Adds: the record found in memory into the data file (query or view). the record found in a Record variable into the data file (query or view)....
<Table>.SelectToFile (Function)
Positions on the data file record corresponding to a row selected in the multi-selection Table control based on a data file.
Format (Property)
The Format property is used to define the data format of a data file.
7. Creating HFSQL files: files physically created
The data model editor allows you to define the structure of the data files....
HCopyRecord (Function)
Copies: the content of the current record (loaded in memory) to the current data file record. the content of the Record variable to the current data file record....
HDeleteAll (Function)
Deletes all records from a data file, an HFSQL view or a query.
<Destination>.CopyRecord (Function)
Copies: the content of the current record (loaded in memory) to the current data file record. the content of the Record variable to the current data file record....
<Source>.Open (Function)
Opens a data file.
HOpen (Function)
Opens a data file.
XML management: Use example
This application example manages an XML file named "Orders......
ScreenToSource (Function)
Automatically initializes: the values of a data file's items in memory with the values from the controls in the window. the value of the WLanguage variables with the value of the window controls. This function is also available for WEBDEV pages....
<Window>.ToSource (Function)
Automatically updates: the values of a data file's items in memory with the values from the controls in the window. the value of the WLanguage variables with the value of the window controls. This function is also available for WEBDEV pages....
ScreenToFile (Function)
Automatically updates: the values of a data file's items in memory with the values from the controls in the window. the value of the WLanguage variables with the value of the window controls. This function is also available for WEBDEV pages....
<Source>.FromWindow (Function)
Automatically initializes: the values of a data file's items in memory with the values from the controls in the window. the value of the WLanguage variables with the value of the window controls. This function is also available for WEBDEV pages....
SourceFromWindow (Function)
Automatically updates: the values of a data file's items in memory with the values from the controls in the window. the value of the WLanguage variables with the value of the window controls. This function is also available for WEBDEV pages....
<Source>.Creation (Function)
Creates an empty data file (".FIC" extension) with the index file and the memo file if necessary.