|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Lists the files found in a directory and returns the list of files. |
|
|
|
|
|
|
|
| Returns the list of triggers applied to one or more HFSQL data files. |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Used to find out the state of a record. |
|
|
|
|
|
|
|
| The Type property is used to get:
the type of element (data file or item) defined programmatically or in the data model editor, view or query.
the type of object.
the type of data held in a Variant.... |
|
|
|
|
|
|
|
| Sets the position on the first record of a data file according to the specified browse item. |
|
|
|
|
|
|
|
| Stores the current file context: current record, filter, pointers. |
|
|
|
|
|
|
|
| Moves backward several records from the current position in the data file, according to a specified item. |
|
|
|
|
|
|
|
| Adds or modifies a trigger on an HFSQL data file. |
|
|
|
|
|
|
|
| Sets the position on the last file record whose value for a specific item is less than or equal to a sought value. |
|
|
|
|
|
|
|
| Defines and enables a filter used to find the exact value of a string item. |
|
|
|
|
|
|
|
| The following SQL functions can be used on the queries written in SQL code (classified by theme)...... |
|
|
|
|
|
|
|
| Allows you to get information about a MongoDB file (gridFS). |
|
|
|
|
|
|
|
| Returns information about a MongoDB database. |
|
|
|
|
|
|
|
| Deletes a collection from a MongoDB database. |
|
|
|
|
|
|
|
| Modifies documents in a collection of a MongoDB database. |
|
|
|
|
|
|
|
| Modifies a document in a collection of MongoDB database. |
|
|
|
|
|
|
|
| Deletes a document from a collection in a MongoDB database. |
|
|
|
|
|
|
|
| Finds documents in a MongoDB collection. |
|
|
|
|
|
|
|
| Checks the existence of an external file. |
|
|
|
|
|
|
|
| Constants used by the geo-localization functions... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Positions on the first row of the query result. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|