|
|
|
|
|
|
|
|
|
|
|
|
|
|
| A sub-query is a query whose result is used by another query... |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Describes a new connection to an external database. |
|
|
|
|
|
|
|
| Locks a record and restricts the access to this record for all the other applications. |
|
|
|
|
|
|
|
| Retrieves the value of the current record before the trigger(s) are executed. |
|
|
|
|
|
|
|
| Creates an empty data file (".FIC" extension) with the index file and the memo file if necessary. |
|
|
|
|
|
|
|
| Locks a data file and restricts the access to this data file for all other sites or applications. |
|
|
|
|
|
|
|
| Returns the number of entries for a given key item. |
|
|
|
|
|
|
|
| Returns an estimate regarding the number of entries for a given key item in a given interval of values. |
|
|
|
|
|
|
|
| Opens a connection to a specific database. |
|
|
|
|
|
|
|
| Link functions are used to link the interface with the data files (and vice versa).... |
|
|
|
|
|
|
|
| Creates a logical alias of a data file (or query) or cancels all existing aliases. |
|
|
|
|
|
|
|
| Unlocks the records of a data file:
locked by HLockFile.
individually locked by a locking read function.... |
|
|
|
|
|
|
|
| Unlocks a record locked by:
HLockRecNum,
a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example).... |
|
|
|
|
|
|
|
| Describes a data file programmatically. |
|
|
|
|
|
|
|
| Closes a data file or all the data files opened by the current user: all the corresponding physical data files are closed for the current user. |
|
|
|
|
|
|
|
| Enables or disables the management of duplicates on a unique key. |
|
|
|
|
|
|
|
| Returns the number of duplicates for a given key item. |
|
|
|
|
|
|
|
| An Item Description variable is used to describe one or more items in a data file programmatically. |
|
|
|
|
|
|
|
| Reorganizes the internal structure of the indexes to optimize the speed for accessing the data. |
|
|
|
|
|
|
|
| Sets the position on a record, based on the approximate position of one of its items. |
|
|
|
|
|
|
|
| Defines and enables a filter used to find the exact value of a string item. |
|
|
|
|
|
|
|
| Crosses a record in a data file. |
|
|
|
|
|
|
|
| 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 check whether a duplicate error occurred. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|