|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Creates a logical alias of a data file (or query) or cancels all existing aliases. |
|
|
|
|
|
|
|
| Regardless of the platform used, the data stored in the HFSQL files is in ANSI format. |
|
|
|
|
|
|
|
| Automatically updates:
the value of the items in a data file with the value of the controls in the page. The data file items bound to the window controls are automatically updated with the values of these controls.
the value of the WLanguage variables with the value of the window controls. The WLanguage variables bound to the page controls are automatically updated with the values of these controls.
This operation is performed regardless of the state of the controls (grayed, inactive or invisible).... |
|
|
|
|
|
|
|
| Modifies the location for the description of subscriber replica (RPL file). |
|
|
|
|
|
|
|
| Builds the value of a composite key to implement a filter (HFilter) or to perform a search (HReadSeekFirst, HReadSeekLast, etc.). |
|
|
|
|
|
|
|
| Converts a numeric value into a binary string in order to perform a search on a numeric key. |
|
|
|
|
|
|
|
| Copies:
the content of the current record (loaded in memory) to the current data file record.
the content of the Record variable to the current data file record.... |
|
|
|
|
|
|
|
| Adds or deletes the spaces found on the right of a text item when reading it. |
|
|
|
|
|
|
|
| Automatically updates the controls of a page with:
the values of the bound items in the current record (loaded in memory) of the data file described in the data model editor. This operation is performed regardless of the state of the controls (grayed, inactive or invisible).
the values of the bound WLanguage variables. This operation is performed regardless of the state of the controls (grayed, inactive or invisible).... |
|
|
|
|
|
|
|
| Enables the filter that was previously created for the specified data file (view or query). |
|
|
|
|
|
|
|
| Re-enables a trigger that was disabled by HDeactivateTrigger. |
|
|
|
|
|
|
|
| Adds:
the record found in memory into the data file (query or view).
the record found in a Record variable into the data file (query or view).... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Cancels an alias that was declared beforehand by HAlias. |
|
|
|
|
|
|
|
| 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).... |
|
|
|
|
|
|
|
| Cancels the current search criterion. |
|
|
|
|
|
|
|
| Used to associate a file with a binary memo item or to cancel the existing link between a file and a binary item. |
|
|
|
|
|
|
|
| Moves several records forward from the current position in the data file, according to a specified item. |
|
|
|
|
|
|
|
| Locks a data file and restricts the access to this data file for all other sites or applications. |
|
|
|
|
|
|
|
| Locks a record and restricts the access to this record for all the other applications. |
|
|
|
|
|
|
|
| Dynamically changes the connection associated with a data file. |
|
|
|
|
|
|
|
| Modifies the physical name of a data file. |
|
|
|
|
|
|
|
| Changes the path to a data file (i.e. directory in which the file will be handled). |
|
|
|
|
|
|
|
| Modifies the location of log files corresponding to an HFSQL data file. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|