HClose (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Closing the tables and the connection

See also

ExecuteSQLQueryAsynchronous

ExécuteRequêteAsynchronous

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HExecuteQuery

HExecuteQueryAsynchronous

HExecuteSQLQuery

HExecuteSQLQueryAsynchronous

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

Closing the tables and the connection

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HClose (Function)

In french: HFerme

Not available with this kind of connection

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. For the HFSQL data files, the following files are closed:

the data file (.FIC),
the index file (.NDX) if it exists,
the memo file (.MMO) if it exists.
the full-text index file (.FTX) if it exists.

When closing the data file:

The locks (on the data file and/or some of its records) are unlocked.
The filters defined on the data file with HFilter are automatically deleted.
The current browses on the data file are canceled.
The current searches on the data file are canceled.

Once the data file is closed, the reassignments performed by HChangeName, HChangeDir and HSubstDir are kept.

If a query was run on the data file, HCancelDeclaration must be called on the query in order for the closing to be effective.

The standby mode can have harmful effects on the data files. We recommend that you close them when the computer might go into standby.

Versions 15 and later

This function is now available for Android applications.

New in version 15

This function is now available for Android applications.

Versions 17 and later

This function is now available for iPhone/iPad applications.

New in version 17

This function is now available for iPhone/iPad applications.

Versions 18 and later

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

New in version 18

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Example

// Close the "Supplier" data file
HClose(Supplier)

IF NOT HClose("") THEN
Error ("Problem when closing data files")
END

Syntax

<Result> = HClose([<Data file>])

<Result>: Boolean

True if the data file was closed,
False otherwise. HError returns more details about the problem.

<Data file>: Optional character string (with or without quotes)

Name of data file to close.
If this name is not specified, HClose will close the last data file 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 data files will be closed.
This parameter can also correspond to the name of a group of files (or custom-folder) defined in the analysis (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.

To close a connection, use HCloseConnection.

Component : wd260hf.dll