PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Modification conflict and status of the record
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Returns the status of a record during a modification conflict.
WINDEV This function must be used 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.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Code of a procedure called to process a modification conflict
FileName is string = HErrorInfo(hErrFile)
// Displays the status of the source record
Trace(HErrorStatusModification(FileName, hRecRead))
// Displays the status of the item for the file record
Trace(HErrorStatusModification(FileName, hRecFile))
// Displays the status of the item for the user record
Trace(HErrorStatusModification(FileName, hRecUser))
Syntax
<Result> = HErrorStatusModification(<File Name> , <Record to Process>)
<Result>: Integer constant
Displays the status of the record.
hStateActiveThe record is active
hStateInvalidRecord status not found (error)
hStateCrossedThe record is crossed
hStateDelThe record is deleted
<File Name>: Character string (with or without quotes)
Name of 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
CrossedConflict of modification statusModification conflictModification conflict
DeletedConflict of modification statusConflict of modification statusXXXX
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Linux wd230hf.so
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment