HErrorStatusModification (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

WLanguage

Management of databases

HFSQL functions

HErrorStatusModification

Presentation

Example

Modification conflict and status of the record

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

Modification conflict and status of the record

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HErrorStatusModification (Function)

In french: HErreurEtatModification

Not available with this kind of connection

Returns the status of a record during a modification conflict.

This function must be used when a modification conflict is not automatically managed (in a procedure or window called to process the modification conflict (HOnError)). HOnError is not available when using stored procedures.

Versions 17 and later

This function is now available for iPhone/iPad applications.

New in version 17

This function is now available for iPhone/iPad applications.

Versions 18 and later

This function is now available in Windows Store apps mode.

New in version 18

This function is now available in Windows Store apps mode.

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.

Note: From version 19, HFSQL is the new name of HyperFileSQL.

Example

// Code of a procedure called to process a modification conflict
FileName is string = HErrorInfo(hErrFile)
// Displays the status of the source record
Trace(HErrorStatusModification(FileName, hRecRead))
// Displays the status of the item for the file record
Trace(HErrorStatusModification(FileName, hRecFile))
// Displays the status of the item for the user record
Trace(HErrorStatusModification(FileName, hRecUser))

Syntax

<Result> = HErrorStatusModification(<File name> , <Record to process>)

<Result>: Integer constant

Displays the status of the record.
hStateActive The record is active
hStateInvalid Record status not found (error)
hStateCrossed The record is crossed
hStateDel The record is deleted

<File name>: Character string (with or without quotes)

Name of data file used.

<Record to process>: Integer constant.

Used to specify the record in which the value of the item must be read.
hRecFile Status of the record in the data file.
hRecRead Status of the source record (read before running HModify).
hRecUser Status of the current record during the call to HModify.

Remarks

Modification conflict and status of the record

When using an application in network, conflicts may occur because of conflicting data entered by the different users. For example:

1. The user X edits the form for the "California" state.

2. The user Y edits the form for the "California" state.

3. The user X renames the state to "California_01".

4. The user Y modifies the name of the state and saves it. A modification conflict occurs during this backup.

A conflict of modification status occurs when the form is deleted by the user X for example.

The different cases are presented in the table below:


Record read	Addition	Crossed	Deleted
Record on disk	Addition	Crossed	Deleted
Addition	Modification conflict	Modification conflict	Modification conflict
Crossed	Conflict of modification status	Modification conflict	Modification conflict
Deleted	Conflict of modification status	Conflict of modification status	XXXX

See Assisted management of HFSQL errors for more details.

Component : wd240hf.dll