ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Incrementing the version number of the data file
  • Multi-file queries
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Determines:
  • 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.
Example
NumVer = HVersion(Client)
// Première évaluation de la version du fichier de données
NumVer is int
NumVer = HVersion(Client)
// Traitements
// Deuxième évaluation de la version du fichier de données
IF NumVer <> HVersion(Client) THEN
	Info("Le fichier de données Client a été modifié.")
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.
Note The function HVersion function can be used on both indexed and 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: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help