|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The first operation to perform in order to use WDSQL is to establish the connection to a database...... |
|
|
|
|
|
|
|
| Returns the approximate position of current record in the data file. |
|
|
|
|
|
|
|
| The SQL functions can be used to handle the MariaDB database...... |
|
|
|
|
|
|
|
| Locks a record and restricts the access to this record for all the other applications. |
|
|
|
|
|
|
|
| Creates an empty data file (".FIC" extension) with the index file and the memo file if necessary. |
|
|
|
|
|
|
|
| Sets the position on a record, based on the approximate position of one of its items. |
|
|
|
|
|
|
|
| Performs the following operations:
If the file does not exist, creates an empty data file (".FIC" file) with the index file and the memo file if necessary. The function is equivalent to HCreation.
If the file exists, opens the file.... |
|
|
|
|
|
|
|
| Duplicates the record read in a data file: the record found in memory is added into the data file (query or view). |
|
|
|
|
|
|
|
| Crosses a record in a data file. |
|
|
|
|
|
|
|
| Returns the date of the last update for the index statistics. |
|
|
|
|
|
|
|
| Sets the position on the first record of a data file according to the specified browse item. |
|
|
|
|
|
|
|
| Deletes a record from a data file (query or view). |
|
|
|
|
|
|
|
| Returns the time of the last update for the index statistics. |
|
|
|
|
|
|
|
| You can use SQL functions to handle the PostgreSQL database...... |
|
|
|
|
|
|
|
| Returns the list of links (Merise type) found in the current analysis or in a specific analysis. |
|
|
|
|
|
|
|
| The project description window allows you to configure various elements of your project...... |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Performs various statistical calculations on the file keys. |
|
|
|
|
|
|
|
| Defines and enables a filter used to find the exact value of a string item. |
|
|
|
|
|
|
|
| Reads a record in a file according to a given record number. |
|
|
|
|
|
|
|
| Defines and enables a "Start with" filter on a file, view or query. |
|
|
|
|
|
|
|
| Defines and enables an "Included between" filter on a file, view or query. |
|
|
|
|
|
|
|
| The Resource property is used to:
find out the resources visible in a Scheduler control.
find out the resource of the Scheduler control that corresponds to the specified index.... |
|
|
|
|
|
|
|
| Configures the isolation mode of transactions for a connection to an HFSQL server. |
|
|
|
|
|
|
|
| Returns the status of a record during a modification conflict. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|