|
|
|
|
|
|
|
|
|
|
|
|
|
|
| A Data Source variable is used to describe a temporary data source (query, view, alias, etc.). |
|
|
|
|
|
|
|
| MySource is used to handle the current data source (file, view or query) associated with a report or with a table based on a data file... |
|
|
|
|
|
|
|
| Determines if a data source has been initialized. |
|
|
|
|
|
|
|
| Lists the data sources declared on a local site. |
|
|
|
|
|
|
|
| Determines if a data source has been initialized. |
|
|
|
|
|
|
|
| Positions on the previous file record according to a browse item. |
|
|
|
|
|
|
|
| Returns the number of records in a file, query or HFSQL view: active records, crossed records, deleted records, etc. |
|
|
|
|
|
|
|
| Initializes a query and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
|
| Initialize:
one or all variables of file items with their default values.
one or all items of a Record variable with their default values.... |
|
|
|
|
|
|
|
| Starts tracking write actions (addition, modification or deletion) performed on a file found in an HFSQL server. |
|
|
|
|
|
|
|
| Sorts an HFSQL view by creating an index on a view item. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Checks whether the current record corresponds to the current filter or search. |
|
|
|
|
|
|
|
| Assigns the specified value to an item of the current record. |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Modifies the current record if it exists, otherwise adds a new record. |
|
|
|
|
|
|
|
| Used to find out the state of a record. |
|
|
|
|
|
|
|
| Returns the time of the last update for the index statistics. |
|
|
|
|
|
|
|
| Rebuilds the file index (".NDX" file). |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL table. |
|
|
|
|
|
|
|
| Sets the position on the last record whose value for a specific item is less than or equal to a sought value (exact-match search). |
|
|
|
|
|
|
|
| Moves several records forward from the current position in the table, according to a specified item. |
|
|
|
|
|
|
|
| Temporarily disables the filter on a table (view or query). |
|
|
|
|
|
|
|
| Used to associate a file with a binary memo item or to cancel the existing link between a file and a binary item. |
|
|
|
|
|
|
|
| Declares a description of table (found in a database schema) in the current project. |
|
|
|
|
|
|
|
| Performs various statistical calculations on the file keys. |
|
|
|
|
|
|
|
| Forbids all the modifications on a table (for all the programs, including the one that requested the no-modification policy). |
|
|
|
|
|
|
|
| Returns:
the number of the current record in the HFSQL table.
the number of the current record in the HFSQL view.... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|