ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

HFSQL management functions
List of functions for HFSQL management...
HRecordToXML (Function)
Retrieves the structure and the value of the current record and exports them into a character string in XML format.
Minute (Property)
The Minute property is used to: Retrieve the minutes from a Time or DateTime variable, or the number of minutes from a Duration. Change the minutes in a Time or DateTime variable, or the number of minutes in a Duration. Retrieve the minutes or the number of minutes from a Date item (in "Date and Time" or "Duration" format) or from a Time item. Modify the minutes or the number of minutes in a Date item (in "Date and Time" or "Duration" format) or in a Time item....
HPrepareQuery (Function)
Initializes a query and declares this query to the database server in order to optimize the next executions of this query.
HEndNoModif (Function)
Unlocks a file that was locked by the same program with HNoModif.
Time (Property)
The Time property enables you to: Retrieve the time from a DateTime variable. Modify the time in a DateTime variable. Retrieve the time from in a Date item (in "Date and Time" format) Modify the time in a Date item ("Date and Time" format)....
HPrepareSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query.
HMigrateLinkedCompositeKey (Function)
Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format.
SourceFromPage (Function)
Automatically updates: the value of the items in a data file with the value of the controls in the page. the value of the WLanguage variables with the value of the page controls....
HDeleteView (Function)
Deletes a previously created view. This function uses the former view mechanism.
HDeactivateAutoFilter (Function)
Disables an automatic filter on the linked files when browsing an XML file.
HImportHF55 (Function)
Imports a Hyper File 5.5 file into an HFSQL Classic file.
ERR_NO_PROJECT
HSeek (Function)
Positions on the first record of the data file whose value for a specific item is greater than or equal to a sought value (generic search by default).
HDeclareExternal (Function)
Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file.
Remote WEBDEV administrator: Modifying a WEBDEV account
To modify a WEBDEV account from the remote WEBDEV administrator:...
Compilation statement: COMPILE IF
The <COMPILE IF> statement allows you to compile (or not) a WLanguage code according to a condition.
HChangePassword (Function)
Changes the password of an HFSQL Classic or HFSQL Client/Server data file....
How to create and run an SQL query through programming?
This help page explains how to create and run an SQL query through programming....
ConfirmAsynchronous (Function)
Displays a non-blocking message in a standard dialog box with the answers "Yes", "No", "Cancel" and calls a WLanguage procedure with the user's response....
InfoAsynchronous (Function)
Displays a non-blocking custom message in a system information window.
WarningAsynchronous (Function)
Displays a custom message in a non-blocking system warning window.
ErrorAsynchronous (Function)
Displays a custom error message in a non-blocking system error window.
ErrorWithTimeoutAsynchronous (Function)
Displays a custom error message in a non-blocking system error window for a given amount of time.
Coloring the procedures
A color (text color) can be assigned to the procedures so that they can be easily classified and identified......