|
|
|
|
|
|
|
|
|
|
- Closing the tables and the connection
HClose (Function) In french: HFerme
 Not available with this kind of connection
Closes one or all the tables opened by the current user. For the HFSQL tables, the following tables are closed: - the table (.FIC),
- the index file (.NDX) if it exists,
- the memo file (.MMO) if it exists.
- the full-text index file (.FTX) if it exists.
- the spatial index file (.SDX) if it exists.
 New in version 2026the semantic index file (.VEX) if it exists.
When closing the table: - The locks (on the table and/or some of its records) are unlocked.
- The filters defined on the table with HFilter are automatically deleted.
- The current iterations on the table are canceled.
- The current searches on the table are canceled.
If a query was executed on the table, HCancelDeclaration must be called on the query in order for the closing to be effective.
IF NOT HClose("") THEN
Error ("Problem when closing tables")
END
Syntax
<Result> = HClose([<Table>])
<Result>: Boolean - True if the table was closed,
- False otherwise. HError returns more details about the problem.
<Table>: Optional character string Name of table to close.
If this name is not specified, HClose will close the last table used by the last HFSQL management function (function starting with "H").
If this parameter is equal to "*" or if it corresponds to an empty string (""), all the opened tables will be closed.
This parameter can also correspond to the name of a group of files (or custom-folder) defined in the database schema (not available in Android and Android widget). Remarks Closing the tables and the connection When all the tables that use the same connection (tables opened on the same database with the same connection parameters) are closed, the connection is automatically closed.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|