|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Defines and enables a filter on a data file, view or query. |
|
|
|
|
|
|
|
| Temporarily disables the filter on a data file (view or query). |
|
|
|
|
|
|
|
| The FilterWithBounds property is used to determine if bounds have been specified for the filter implemented by HFilter on an HFSQL data file, view or query. |
|
|
|
|
|
|
|
| The FilteredItem property is used to identify the item that has a filter implemented by HFilter. |
|
|
|
|
|
|
|
| Defines and enables a filter on a data file, view or query. |
|
|
|
|
|
|
|
| Temporarily disables the filter on a data file (view or query). |
|
|
|
|
|
|
|
| The FilterCondition property gets the selection condition set by HFilter on a data file, HFSQL view or query.
|
|
|
|
|
|
|
|
| A filter is used to define programmatically a selection of records corresponding to one or more criteria... |
|
|
|
|
|
|
|
| List of HFSQL properties... |
|
|
|
|
|
|
|
| The Pivot Table control dynamically displays data coming from the crosscheck of different files found in a database...... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Sorts an HFSQL view by creating an index on a view item. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data...... |
|
|
|
|
|
|
|
| The Provider property is used to manage the type of a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
| This help page explains how to create a query with a calculation formula with the query editor.... |
|
|
|
|
|
|
|
| The User property is used to manage the user of a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
| This chapter presents the following topics...... |
|
|
|
|
|
|
|
| This help page presents the main recommendations for optimizing the security and performance of an HFSQL Client/Server database according to the constraints and desired features...... |
|
|
|
|
|
|
|
| Creates a scheduled task on an HFSQL server:
stored procedure,
backup,
optimization,
refresh of materialized view.... |
|
|
|
|
|
|
|
| Modifies a scheduled task on an HFSQL server:
stored procedure,
backup,
optimization,
refresh of materialized view.... |
|
|
|
|
|
|
|
| Sorts an HFSQL view by creating an index on a view item. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Suspends the execution of an HFSQL cluster. The nodes of the cluster will no longer accept any connection from the client applications. |
|
|
|
|
|
|
|
| Creates a scheduled task on an HFSQL server:
stored procedure,
backup,
optimization,
refresh of materialized view.... |
|
|
|
|
|
|
|
| Modifies a scheduled task on an HFSQL server:
stored procedure,
backup,
optimization,
refresh of materialized view.... |
|
|
|
|
|
|
|
| This help page explains how to optimize the connection times to the HFSQL Client/Server databases by limiting the network traffic...... |
|
|
|
|
|
|
|
| The Access property is used to manage the type of access of a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
| The ExecutionCompleted property is used to determine whether the execution of a query or view (HFSQL Classic or Client/Server) is completed.... |
|
|
|
|
|
|
|
| The query editor is used to automatically create queries on the data files...... |
|
|
|
|
|
|
|
| The Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
| The data model editor allows you to define the structure of the data files.... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|