|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Deletes all records from a table, an HFSQL view or a query. |
|
|
|
|
|
|
|
| Unlocks the records of a table:
locked by HLockFile.
individually locked by a locking read function.... |
|
|
|
|
|
|
|
| Imports a Text 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).... |
|
|
|
|
|
|
|
| Used to modify the management mode of memo items. |
|
|
|
|
|
|
|
| Creates an empty table (extension ".FIC") with index file, full-text index file, spatial index file, and memo file if required. |
|
|
|
|
|
|
|
| Sets the position on the first record of a table according to the specified browse item. |
|
|
|
|
|
|
|
| Modifies the physical name of a table. |
|
|
|
|
|
|
|
| Modifies the search mode of physical tables (.FIC, .NDX, ...). |
|
|
|
|
|
|
|
| Enables the filter that was previously created for the specified table (view or query). |
|
|
|
|
|
|
|
| Forces the operating system of the computer where the tables are found to write data onto the disk. |
|
|
|
|
|
|
|
| Exports the records found in a table (HFSQL or OLE DB), view or query to an XML file. |
|
|
|
|
|
|
|
| Describes a table programmatically. |
|
|
|
|
|
|
|
| Determines:
whether a file exists, which means whether it was physically created (HCreation or HCreationIfNotFound).
whether a view or a query was defined.... |
|
|
|
|
|
|
|
| Defines and enables a "Start with" filter on a file, view or query. |
|
|
|
|
|
|
|
| Assigns the specified value to an item of the current record. |
|
|
|
|
|
|
|
| Locks a table and restricts the access to this table for all other sites or applications. |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| Moves backward several records from the current position in the table, according to a specified item. |
|
|
|
|
|
|
|
| Automatically initializes:
the values of a table'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.... |
|
|
|
|
|
|
|
| Exports the records found in a table (HFSQL or OLE DB), view or query to a JSON file. |
|
|
|
|
|
|
|
| Returns the characteristics of binary and text memos. |
|
|
|
|
|
|
|
| Returns the time of the last update for the index statistics. |
|
|
|
|
|
|
|
| Returns the list of keys in a table (query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|