PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • Incrementing the version number of the data file
  • Multi-file queries
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Allows you to find out:
  • whether the content of a data file was modified.
  • whether the content of a data file used by a query was modified.
This function is used to detect the modifications made to a data file shared among several programs. If a modification is detected, you have the ability to refresh the data displayed in the window or in the page.
Versions 18 and later
Android Widget This function is now available in Android widget mode.
Android This function is now available for Android applications (for HFSQL data files).
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.
Android This function is now available for Android applications (for HFSQL data files).
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.
Android This function is now available for Android applications (for HFSQL data files).
Universal Windows 10 App This function is now available in Windows Store apps mode.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 19 and later
iPhone/iPad This function is now available for iPhone/iPad applications.
New in version 19
iPhone/iPad This function is now available for iPhone/iPad applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
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.
Example
VerNum = HVersion(Customer)
// First evaluation of the data file version
VerNum is int
VerNum = HVersion(Customer)
// Processes
// Second evaluation of the data file version
IF VerNum <> HVersion(Customer) THEN
Info("The Customer data file was modified.")
END
Syntax
<Result> = HVersion([<Data file or query>])
<Result>: Integer
Version number of the data file.
OLE DBNative Connectors (Native Accesses) The version number is always equal to 0.
<Data file or query>: Optional character string
  • Name of the data file used.
  • Name of the query used.
  • If this parameter is not specified, HVersion will handle the last data file (last query) used.
Java The data file used must be an HFSQL data file. Otherwise, the version number is always equal to 0.
Remarks

Incrementing the version number of the data file

When creating the data file, the version number is initialized to 1. This number is incremented whenever the file content is modified (HAdd, HWrite, HModify, TableSave, TableDelete, HFree, HDelete, HCross). The number is incremented if the function is successful.
Remark: HVersion can be used on indexed or non-indexed data files.

Multi-file queries

In the case of a multi-file query, HVersion returns the sum of the HVersion of all data files used in the query.
Component: wd270hf.dll
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment