|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Connects the current application to a database that will be queried by SQL through a Webservice proxy (SOAP). |
|
|
|
|
|
|
|
| Stores the current file context: current record, filter, pointers. |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Usage example of the HNbRec function |
|
|
|
|
|
|
|
| Executes a SELECT query asynchronously. |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item is greater than or equal to a sought value (generic search). |
|
|
|
|
|
|
|
| Sets the position on the first record according to a browse item. |
|
|
|
|
|
|
|
| Validates the current transaction:
the modifications performed on the data file since the start of transaction (HTransactionStart) are validated.
the transaction file is deleted (if the transaction is the last transaction in progress for a network application)
the records locked in read-only by the transaction are unlocked.... |
|
|
|
|
|
|
|
| Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| The assisted replication through programming is used to implement a replication on an existing application while controlling the synchronization in the application itself...... |
|
|
|
|
|
|
|
| Changes the path to a data file (i.e. directory in which the file will be handled). |
|
|
|
|
|
|
|
| Reads a record in a file according to a given record number. |
|
|
|
|
|
|
|
| Transfers the result of a query to a Table control populated programmatically (a List Box or Combo Box control), with the possibility of Partial Fetch (the result is retrieved by blocks of rows). |
|
|
|
|
|
|
|
| Used to lock:
The entire data table, in read and write mode. Its data cannot be accessed by other computers.
The records selected by the query. This data cannot be accessed by the other computers. This method can be used to update records for example.... |
|
|
|
|
|
|
|
| Positions on the previous file record according to a browse item. |
|
|
|
|
|
|
|
| If a transaction is in progress, cancels all the operations performed on the data files in transaction since the start of transaction. |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| The mathematical SQL functions that can be used on the queries written in SQL code are as follows...... |
|
|
|
|
|
|
|
| Used to associate a file with a binary memo item or to cancel the existing link between a file and a binary item. |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item is strictly equal to a sought value (exact-match search). |
|
|
|
|
|
|
|
| Used to find out the number of records added, modified or deleted when running the last query of the current context. |
|
|
|
|
|
|
|
| Usage example of the HForward function |
|
|
|
|
|
|
|
| Usage example of the HReadSeek function |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|