|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Defines and enables an "Included between" filter on a file, view or query. |
|
|
|
|
|
|
|
| Deletes a user associated with a connection to the HFSQL server. |
|
|
|
|
|
|
|
| Used to check whether a duplicate error occurred. |
|
|
|
|
|
|
|
| Extracts the content of a binary memo item from an HFSQL file, a query or an HFSQL view to a physical file (on disk). |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Runs a view that was created beforehand (can be used to refresh the view data for example). This function uses the former view mechanism. |
|
|
|
|
|
|
|
| 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 connection to a database. |
|
|
|
|
|
|
|
| Determines:
whether a file exists, which means whether it was physically created (HCreation or HCreationIfNotFound).
whether a view or a query was defined.... |
|
|
|
|
|
|
|
| Defines and enables a filter on a data file, view or query. |
|
|
|
|
|
|
|
| Defines and enables a "Start with" filter on a file, view or query. |
|
|
|
|
|
|
|
| Deletes (from the server) a group of users associated with a connection. |
|
|
|
|
|
|
|
| Defines and enables a filter used to find the exact value of a string item. |
|
|
|
|
|
|
|
| Begins, commits or rolls back a transaction:
on the files of a database opened by SQLConnect,
on the files of a database opened by a connection (OLE DB or Native Access/Native Connector) described in the data model editor or by HOpenConnection.... |
|
|
|
|
|
|
|
| Forces the operating system of the computer where the data files are found to write data onto the disk. |
|
|
|
|
|
|
|
| Enables or disables the management of duplicates on a unique key. |
|
|
|
|
|
|
|
| Enables or disables the management of an integrity constraint on a file link. |
|
|
|
|
|
|
|
| Enables or disables log management on a file. |
|
|
|
|
|
|
|
| Enables or disables the management of .REP file. |
|
|
|
|
|
|
|
| Temporarily disables (or re-enables) the replication. |
|
|
|
|
|
|
|
| Enables or disables the management of transactions for one or more files. |
|
|
|
|
|
|
|
| Enables or disables the management of triggers. |
|
|
|
|
|
|
|
| List all the tables that can be accessed by the connected database system. |
|
|
|
|
|
|
|
| Returns the characteristics of an HFSQL Classic or Client/Server data file.... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|