HVersion (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Incrementing the version number of the data file

Multi-file queries

See also

ExecuteQueryAsynchronous

ExecuteSQLQueryAsynchronous

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HExecuteQuery

HExecuteQueryAsynchronous

HExecuteSQLQuery

HExecuteSQLQueryAsynchronous

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

Incrementing the version number of the data file
Multi-file queries

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HVersion (Function)

In french: HVersion

Not available with this kind of connection

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

This function is now available in Android Widget mode.

This function is now available for Android applications (for HFSQL data files).

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 for Android applications (for HFSQL data files).

This function is now available in Windows Store apps mode.

This function is now available in Android Widget mode.

This function is now available for Android applications (for HFSQL data files).

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

This function is now available for iPhone/iPad applications.

New in version 19

This function is now available for iPhone/iPad applications.

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.

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.
The version number is always equal to 0.

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

Name of data file used.
Name of the query used.
If this parameter is not specified, HVersion handles the last data file (or the last query) used.
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: wd260hf.dll