HErrorModification (Function)

Note: 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 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

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

<Result> = HErrorModification(<File name> , <Item name> [, <Item subscript>] , <Record to read>)

<Result>: Character string

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

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

Name of data file used.

<Item name>: 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).

Component : wd240hf.dll