|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Returns the approximate position of current record in the data file. |
|
|
|
|
|
|
|
| Modifies the location of log files corresponding to an HFSQL data file. |
|
|
|
|
|
|
|
| Adds or modifies a trigger on an HFSQL data file. |
|
|
|
|
|
|
|
| Returns an estimate regarding the number of entries for a given key item in a given interval of values. |
|
|
|
|
|
|
|
| Used to update the structure of an HFSQL data file by performing an automatic data modification (also called data synchronization). |
|
|
|
|
|
|
|
| Locks a data file and restricts the access to this data file for all other sites or applications. |
|
|
|
|
|
|
|
| Sets the position on a record, based on the approximate position of one of its items. |
|
|
|
|
|
|
|
| The Month property is used to:
Retrieve the month from a Date or DateTime variable.
Modify the month in a Date or DateTime variable.
Retrieve the month from a Date item (in "Simple date" or "Date and Time" format)
Modify the month in a Date item (in "Simple Date" or "Date and Time" format)... |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Duplicates the record read in a data file: the record found in memory is added into the data file (query or view). |
|
|
|
|
|
|
|
| Enables or disables the management of transactions for one or more files. |
|
|
|
|
|
|
|
| Sets the position on the first record of a data file according to the specified browse item. |
|
|
|
|
|
|
|
| Crosses a record in a data file. |
|
|
|
|
|
|
|
| Used to:
Delete a declaration made previously using HDeclare, HDeclareExternal, HDescriveFile. After this operation, the data file is no longer recognized by the HFSQL engine.
Free the resources of a query (after calling HExecuteQuery or HExecuteSQLQuery).... |
|
|
|
|
|
|
|
| Locks a record and restricts the access to this record for all the other applications. |
|
|
|
|
|
|
|
| Dynamically changes the connection associated with a data file. |
|
|
|
|
|
|
|
| Changes the path to a data file (i.e. directory in which the file will be handled). |
|
|
|
|
|
|
|
| Returns the time of the last update for the index statistics. |
|
|
|
|
|
|
|
| Returns the date of the last update for the index statistics. |
|
|
|
|
|
|
|
| Deletes a record from a data file (query or view). |
|
|
|
|
|
|
|
| Defines and enables a filter used to find the exact value of a string item. |
|
|
|
|
|
|
|
| Converts a value from a unit to another one. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|