<Source>.Version (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

Managing databases

HFSQL functions

Prefix syntax

Version

Presentation

Example

Incrementing the version number of the data file

Multi-file queries

See also

CloseConnection

FileExist

InfoFile

OpenConnection

RefreshView

SetIntegrity

CopyRecord

ExportJSONString

ActivateAutoFilter

ActivateFilter

Add

Alias

Backward

BuildKeyValue

CancelDeclaration

CancelSeek

ChangeConnection

ChangeDir

ChangeKey

ChangeLocation

ChangeLogDir

ChangeName

CheckIndex

CheckMemo

CheckStructure

CheckUnaltered

CompareItem

CreateView

Creation

CreationIfNotFound

Cross

DeactivateAutoFilter

DeactivateFilter

Declare

DeclareExternal

Delete

DeleteAll

DeleteView

DescribeFile

DuplicateRecord

EndNoModif

ErrorModification

ErrorStatusModification

ExecuteQuery

ExecuteQueryAsynchronous

ExecuteSQLQuery

ExecuteSQLQueryAsynchronous

ExecuteView

ExportCSV

ExportJSON

ExportXLS

ExportXML

ExtractMemo

FTListWord

FileExist

Filter

FilterContains

FilterIdentical

FilterIncludedBetween

FilterStartsWith

First

Flush

Forward

Found

Free

FreeQuery

GetCurrentPosition

HistoryModification

ImportHF55

ImportJSON

ImportText

ImportXLS

ImportXML

Index

IndexingInProgress

InfoFile

InfoMemo

InitSubscriber

JSONToRecord

Last

LinkMemo

ListFullTextIndex

ListItem

ListKey

ListLink

ListQueryParameter

ListStopWord

ListSynonym

LockFile

LockRecNum

MergeView

MigrateLinkedCompositeKey

Mode

Modify

ModifyStructure

NbRec

NoModif

OnError

Open

Optimize

Out

Password

PrepareQuery

PrepareSQLQuery

Read

ReadFirst

ReadLast

ReadNext

ReadPrevious

ReadSeek

ReadSeekFirst

ReadSeekLast

RecNum

RecordDate

RecordToJSON

RecordToString

RecordToXML

Reset

RestorePosition

RetrieveItem

RetrieveRecord

Save

SavePosition

Security

Seek

SeekFirst

SeekLast

SetDuplicates

SetMemo

SetPosition

SortView

State

ToFile

ToItem

UnlockFile

UnlockRecNum

Version

ViewToFile

Write

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

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Source>.Version (Function)

In french: <Source>.Version

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.

Example

VerNum = Customer.Version()

// First evaluation of the data file version
VerNum is int
VerNum = Customer.Version()
// Processes
// Second evaluation of the data file version
IF VerNum <> Customer.Version() THEN
Info("The Customer data file was modified.")
END

Syntax

<Result> = <Source>.Version()

<Result>: Integer

Version number of the data file.
The version number is always equal to 0.

<Source>: Type corresponding to the specified source

Name of the data file used.
Name of the 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 (<Source>.Add, <Source>.Write, <Source>.Modify, <Table>.Save, <Table>.Delete, <Source>.Free, <Source>.Delete, <Source>.Cross). The number is incremented if the function is successful.

Remark: <Source>.Version can be used on indexed or non-indexed data files.

Multi-file queries

In the case of a multi-file query, <Source>.Version returns the sum of the <Source>.Version of all data files used in the query.

Component: wd270hf.dll