|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The following SQL functions can be used on the queries written in SQL code (classified by theme)...... |
|
|
|
|
|
|
|
| The mathematical SQL functions that can be used on the queries written in SQL code are as follows...... |
|
|
|
|
|
|
|
| Modifies the specified record or the record found in memory in the data file (query or view). |
|
|
|
|
|
|
|
| Creates an HFSQL view from two previously created views (HCreateView). This function uses the former view mechanism. |
|
|
|
|
|
|
|
| The Year property is used to:
Get the year from a Date or DateTime variable or item.
Change the year in a Date or DateTime variable or item.... |
|
|
|
|
|
|
|
| Deletes a record from a data file (query or view). |
|
|
|
|
|
|
|
| To specify the selection conditions in an SQL query, you can use...... |
|
|
|
|
|
|
|
| Used to associate a file with a binary memo item or to cancel the existing link between a file and a binary item. |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file. |
|
|
|
|
|
|
|
| Unlocks the records of a data file:
locked by HLockFile.
individually locked by a locking read function.... |
|
|
|
|
|
|
|
| Returns the characteristics of an HFSQL Classic or Client/Server data file.... |
|
|
|
|
|
|
|
| Customizes the management of HFSQL errors. |
|
|
|
|
|
|
|
| Imports a JSON file into a data file in HFSQL Classic format (data file described in the data model editor or declared by HDeclare, HDeclareExternal or HDescribeFile). |
|
|
|
|
|
|
|
| Returns the content of an item found in the current record (in the data file, view, query, ...). |
|
|
|
|
|
|
|
| Assigns the specified value to an item of the current record. |
|
|
|
|
|
|
|
| Enables or disables the management of duplicates on a unique key. |
|
|
|
|
|
|
|
| Closes a data file or all the data files opened by the current user: all the corresponding physical data files are closed for the current user. |
|
|
|
|
|
|
|
| Imports an XML file into an HFSQL Classic or Client/Server data file (data file described in the data model editor or declared by HDeclare, HDeclareExternal or HDescribeFile).... |
|
|
|
|
|
|
|
| Defines the password used to create or open a data file. |
|
|
|
|
|
|
|
| The generation is used to create the WINDEV classes ("...... |
|
|
|
|
|
|
|
| Returns the list of synonyms used by a full-text index. |
|
|
|
|
|
|
|
| Returns the list of stop words used by a full-text index. |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| Indicates the type of data and the data to copy/move during Drag/Drop.... |
|
|
|
|
|
|
|
| Imports an XLS file into a data file in HFSQL Classic or Client/Server format (data file described in the data model editor, or declared by HDeclare, HDeclareExternal or HDescribeFile).... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|