ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
HErrorModification (Function)
In french: HErreurModification
ODBCNot 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 (for example, in a procedure or window called by the HFSQL engine to handle the modification conflict).
  • check if a modification conflict occurred.
Example
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 data file record item
	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 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:
hRecFileValue of the item currently saved in the data file.
hRecReadValue of the item for the source record (read before the modification performed by HModify).
hRecUserValue 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
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 12/06/2024

Send a report | Local help