Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Closing the tables and the connection
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
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 <Source>.Filter are automatically deleted.
  • The current iterations 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 <Source>.ChangeName, <Source>.ChangeDir and HSubstDir are kept.
If a query was executed on the data file, <Source>.CancelDeclaration must be called on the query in order for the closing to be effective.
// Close the "Supplier" data file
<Result> = <Source>.Close()
<Result>: Boolean
  • True if the data file was closed,
  • False otherwise. HError returns more details about the problem.
<Source>: Type corresponding to the specified source
Name of data file to close.

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 <Connection variable>.CloseConnection.
Component: wd290hf.dll
Minimum version required
  • Version 25
This page is also available for…
Click [Add] to post a comment

Last update: 07/06/2023

Send a report | Local help