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
  • Modification conflict and status of the record
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Returns the status of a record during a modification conflict.
WINDEV This function must be used only 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.
Example
// Code d'une procédure appelée pour le traitement d'un conflit de modification
NomFichier is string = HErrorInfo(hErrFile)
// Affiche l'état de l'enregistrement original
Trace(HErrorStatusModification(NomFichier, hRecRead))
// Affiche l'état de la rubrique de l'enregistrement du fichier
Trace(HErrorStatusModification(NomFichier, hRecFile))
// Affiche l'état de la rubrique de l'enregistrement utilisateur
Trace(HErrorStatusModification(NomFichier, hRecUser))
Syntax
<Result> = HErrorStatusModification(<Data file> , <Record to process>)
<Result>: Integer constant
Displays the status of the record.
hStateActiveThe record is active
hStateCrossedThe record is crossed
hStateDelThe record is deleted
hStateInvalidRecord status not found (error)
<Data file>: Character string
Name of the data file used.
<Record to process>: Integer constant.
Used to specify the record in which the value of the item must be read.
hRecFileStatus of the record in the data file.
hRecReadStatus of the source record (read before running HModify).
hRecUserStatus 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 readAdditionCrossedDeleted
Record on disk
AdditionModification conflictModification conflictModification conflict
CrossedModification status conflictModification conflictModification conflict
DeletedModification status conflictModification status conflictXXXX

WINDEV For more details, see HFSQL error handling help.
Component: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/28/2025

Send a report | Local help