PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
New WINDEV, WEBDEV, WINDEV Mobile 25 feature!
  • Closing the tables and the connection
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
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 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 <Source>.ChangeName, <Source>.ChangeDir 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.
Windows Mobile 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
Android This function is now available for Android applications.
New in version 15
Android This function is now available for Android applications.
Android This function is now available for Android applications.
Versions 17 and later
iPhone/iPad This function is now available for iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for iPhone/iPad applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Versions 18 and later
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App 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
Supplier.Close()
Syntax
<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.
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 : wd250hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment