|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Used to indicate the specific working hours per day in an Organizer control. |
|
|
|
|
|
|
|
The WorkingHourEnd property is used to identify and change the end time of working hours used:- by an Organizer control.
- by a Scheduler control.
- by a Gantt Chart column (in a Table or TreeView Table control).
|
|
|
|
|
|
|
|
| Used to indicate the specific working hours per day in an Organizer control. |
|
|
|
|
|
|
|
The WorkingHourStart property gets and sets the start time of working hours used: - by an Organizer control.
- by a Scheduler control.
- by a Gantt Chart column (in a Table or TreeView Table control).
|
|
|
|
|
|
|
|
| Defines and enables a "Contains" filter on a table, view or query. |
|
|
|
|
|
|
|
| Initializes:
one or all variables of file items with their default values.
one or all items of a Record variable with their default values.... |
|
|
|
|
|
|
|
| Executes a SELECT query asynchronously. |
|
|
|
|
|
|
|
| Defines the password used to create or open a table. |
|
|
|
|
|
|
|
| Restarts the logging process on a file. |
|
|
|
|
|
|
|
| Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format. |
|
|
|
|
|
|
|
| Defines the mode for comparing tables. |
|
|
|
|
|
|
|
| Used to update the structure of an HFSQL table by performing an automatic data modification (also called data synchronization). |
|
|
|
|
|
|
|
| Stores the current context of a table: current record, filter, read pointers. |
|
|
|
|
|
|
|
| Checks that one or all records in an unalterable table have not been modified (e.g. with a hexadecimal editor). |
|
|
|
|
|
|
|
| Writes a record into a table without updating the indexes corresponding to all keys used in the table. |
|
|
|
|
|
|
|
| Imports JSON data into the current record. |
|
|
|
|
|
|
|
| Performs the following operations:
If the table doesn't exist, create an empty table (file with ".FIC" extension) with the index file, the full-text index file and the memo file if necessary. The function is equivalent to HCreation.
If the table exists, opens the table.... |
|
|
|
|
|
|
|
| Crosses a record in a table. |
|
|
|
|
|
|
|
| Defines and enables an "Included between" filter on a file, view or query. |
|
|
|
|
|
|
|
| Imports an XML file into an HFSQL Classic or Client/Server table. This table must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile).... |
|
|
|
|
|
|
|
| Modifies the location of log files corresponding to an HFSQL table. |
|
|
|
|
|
|
|
| Enables or disables the automatic security mechanism on one or more tables. |
|
|
|
|
|
|
|
| Returns information about the lock set on a table, on one or all the records in a table. |
|
|
|
|
|
|
|
| Enables or disables the management of transactions for one or more files. |
|
|
|
|
|
|
|
| Adds:
the record found in memory into the table (query or view).
the record found in a Record variable into the table (query or view).... |
|
|
|
|
|
|
|
| Returns an estimate regarding the number of entries for a given key item in a given interval of values. |
|
|
|
|
|
|
|
| Initializes a query and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
|
| Saves the modifications performed in an HFSQL view (by HModify, HDelete or HCross) in the corresponding table. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Creates an HFSQL view from two previously created views (HCreateView). This function uses the former view mechanism. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|