|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Defines and enables a filter on a table, view or query. |
|
|
|
|
|
|
|
| Temporarily disables the filter on a table (view or query). |
|
|
|
|
|
|
|
| A filter is used to define programmatically a selection of records corresponding to one or more criteria... |
|
|
|
|
|
|
|
| The FilterWithBounds property is used to determine if bounds have been specified for the filter implemented by HFilter on an HFSQL table, view or query. |
|
|
|
|
|
|
|
| Temporarily disables the filter on a table (view or query). |
|
|
|
|
|
|
|
| The FilterCondition property gets the selection condition set by HFilter on a table, HFSQL view, or query.
|
|
|
|
|
|
|
|
| Defines and enables a filter on a table, view or query. |
|
|
|
|
|
|
|
| The FilteredItem property is used to identify the item that has a filter implemented by HFilter. |
|
|
|
|
|
|
|
| Allows you to manage the automatic update of HFSQL Client/Server servers and to define how often to check for updates.... |
|
|
|
|
|
|
|
| This chapter presents the following topics...... |
|
|
|
|
|
|
|
| In SQL language, an external join is used to exclude or include file records with or without correspondences in the linked files...... |
|
|
|
|
|
|
|
| This help page explains how to optimize the connection times to the HFSQL Client/Server databases by limiting the network traffic...... |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| Sorts an HFSQL view by creating an index on a view item. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| The Provider property is used to manage the type of a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
| The User property is used to manage the user of a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
| Indicates that a reindex operation is currently performed on an HFSQL table and returns the percentage of reindexing already performed. |
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data...... |
|
|
|
|
|
|
|
| Sorts an HFSQL view by creating an index on a view item. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Indicates that a reindex operation is currently performed on an HFSQL table and returns the percentage of reindexing already performed. |
|
|
|
|
|
|
|
| Returns the list of WINDEV or WEBDEV database schemas (in HFSQL Classic format) available in a given directory. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|