HErrorModification (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HErrorModification (Function)

In french: HErreurModification

Not available with this kind of connection

Allows you to:

In the event of a modification conflict: return the value of a record item. This value is returned as a character string (empty string for binary memos).
Note This function should only be used when custom management of modification conflicts (e.g. in a procedure or window called by the HFSQL engine to handle the modification conflict).
check if a modification conflict occurred.

Example

LOOP
	// Extrait la nième rubrique de la liste des rubriques en conflit
	UneRubrique = ExtractString(ListeRubrique, i, CR)
	// On sort si on n'a plus de rubrique
	IF UneRubrique = EOT THEN BREAK // Sortie si plus de rubrique en conflit

	// Affiche la valeur de la rubrique de l'enregistrement original
	Trace(HErrorModification(NomFichier, UneRubrique, hRecRead))
	// Affiche la valeur de la rubrique de l'enregistrement du fichier de données
	Trace(HErrorModification(NomFichier, UneRubrique, hRecFile))
	// Affiche la valeur de la rubrique de l'enregistrement utilisateur
	Trace(HErrorModification(NomFichier, UneRubrique, hRecUser))
END

Syntax

Return the value of an item of a record Hide the details

<Result> = HErrorModification(<Data file> , <Item> [, <Item index>] , <Record to read>)

<Result>: Character string

Content of the requested item,
Empty string ("") if no error occurred.

<Data file>: Character string

Name of the data file used.

<Item>: Character string

Name of the item used.

<Item index>: Optional integer

Index of the item for array items only. This parameter is not required for the other types of items.

<Record to read>: Integer constant

Used to specify the record for which the information must be read:
hRecFile Value of the item currently saved in the data file.
hRecRead Value of the item for the source record (read before the modification performed by HModify).
hRecUser Value of the item for the current record when the modification is performed (HModify).

Check if a modification conflict occurred Hide the details

<Result> = HErrorModification()

<Result>: Boolean

True if a modification error occurred,
False otherwise (no conflict).

Business / UI classification: Business Logic

Component: wd300hf.dll