|
|
|
|
|
|
|
List of functions for HFSQL management... |
|
|
|
|
|
|
Retrieves the structure and the value of the current record and exports them into a character string in XML format. |
|
|
|
|
|
|
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.... |
|
|
|
|
|
|
Initializes a query and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
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).... |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format. |
|
|
|
|
|
|
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.... |
|
|
|
|
|
|
Deletes a previously created view. This function uses the former view mechanism. |
|
|
|
|
|
|
Disables an automatic filter on the linked files when browsing an XML file. |
|
|
|
|
|
|
Imports a Hyper File 5.5 file into an HFSQL Classic file. |
|
|
|
|
|
|
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). |
|
|
|
|
|
|
Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. |
|
|
|
|
|
|
To modify a WEBDEV account from the remote WEBDEV administrator:... |
|
|
|
|
|
|
The <COMPILE IF> statement allows you to compile (or not) a WLanguage code according to a condition. |
|
|
|
|
|
|
Changes the password of an HFSQL Classic or HFSQL Client/Server data file.... |
|
|
|
|
|
|
This help page explains how to create and run an SQL query through programming.... |
|
|
|
|
|
|
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.... |
|
|
|
|
|
|
Displays a non-blocking custom message in a system information window. |
|
|
|
|
|
|
Displays a custom message in a non-blocking system warning window. |
|
|
|
|
|
|
Displays a custom error message in a non-blocking system error window. |
|
|
|
|
|
|
Displays a custom error message in a non-blocking system error window for a given amount of time. |
|
|
|
|
|
|
A color (text color) can be assigned to the procedures so that they can be easily classified and identified...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|