HErrorModification (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

ExecuteQueryAsynchronous

ExecuteSQLQueryAsynchronous

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HExecuteQuery

HExecuteQueryAsynchronous

HExecuteSQLQuery

HExecuteSQLQueryAsynchronous

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HErrorModification (Function)

In french: HErreurModification

Not available with this kind of connection

Used to:

If modification conflict occurs: return the value of an item of a record. This value is returned as a character string (empty string for binary memos).
Remark: this function must only be used during a custom management of modification conflicts (in a procedure or window called by the HFSQL engine to process the modification conflict for example).
Versions 24 and later
check if a modification conflict occurred.
New in version 24
check if a modification conflict occurred.
check if a modification conflict occurred.

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.

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

Example

See additional examples

LOOP
// Extracts the nth item from the list of items in conflict
AnItem = ExtractString(ItemList, i, CR)
// Exit if no other item
IF AnItem = EOT THEN BREAK // Exit if no other item in conflict

// Displays the value of the item for the source record
Trace(HErrorModification(FileName, AnItem, hRecRead))
// Displays the value of the item for the file record
Trace(HErrorModification(FileName, AnItem, hRecFile))
// Displays the value of the item for the user record
Trace(HErrorModification(FileName, AnItem, hRecUser))
END

Syntax

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

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

<Result>: Character string

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

<Data file>: Character string (with or without quotes)

Name of data file used.

<Item>: Character string (with or without quotes)

Name of item used.

<Item subscript>: Optional integer

Subscript 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).

Versions 24 and later

Check if a modification conflict occurred Hide the details

<Result> = HErrorModification()

<Result>: Boolean

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

New in version 24

Check if a modification conflict occurred Hide the details

<Result> = HErrorModification()

<Result>: Boolean

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

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: wd260hf.dll