HUnlockRecNum (Function)

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

Management of databases

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HUnlockRecNum (Function)

In french: HDébloqueNumEnr

Not available with these kinds of connection

Unlocks a record that was locked by:

HLockRecNum,
a read function used with a locking parameter (for example, HRead used with the hLockWrite or hLockReadWrite constant)

Note: HUnlockRecNum cannot be used to unlock a record locked by another application.

This function can be used with HFSQL Client/Server data files or with data files handled by Native Accesses. This function is not available for HFSQL Mobile.

Versions 16 and later

This function is now available for the Java applications.

This function is available for the HFSQL data files only. It is not available for the data files accessed by JDBC.

New in version 16

This function is now available for the Java applications.

This function is available for the HFSQL data files only. It is not available for the data files accessed by JDBC.

This function is now available for the Java applications.

This function is available for the HFSQL data files only. It is not available for the data files accessed by JDBC.

Versions 17 and later

This function is now available for the iPhone/iPad applications.

New in version 17

This function is now available for the iPhone/iPad applications.

Versions 18 and later

This function is now available in Android Widget mode.

This function is now available for the Android applications (for the HFSQL data files).

This function is now available in Windows Store apps mode.

New in version 18

This function is now available in Android Widget mode.

This function is now available for the Android applications (for the HFSQL data files).

This function is now available in Windows Store apps mode.

This function is now available in Android Widget mode.

This function is now available for the Android applications (for the HFSQL data files).

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

// Lock
HLockRecNum(CUSTOMER, hCurrentRecNum, hLockReadWrite)
// Modify the record
...
// Unlock
HUnlockRecNum(CUSTOMER, hCurrentRecNum)

Syntax

<Result> = HUnlockRecNum([<File Name> [, <Record Number>]])

<Result>: Boolean

True if the record was unlocked,
False if a problem occurred. HError is used to identify the error.

<File Name>: Optional character string (with or without quotes)

Name of data file used.
If this name is not specified, HUnlockRecNum handles the last data file used by the last function for HFSQL management (starting with the letter H).

<Record Number>: Optional integer

Number of the record to unlock.
If this number is not specified (equal to 0 or to the hCurrentRecNum constant), HUnlockRecNum handles the current record.
HUnlockRecNum only unlocks the current record. You cannot specify a record number other than the current one (to specify the current record number, use the hCurrentRecNum constant).

Remarks

HUnlockRecNum has no effect if:

The data file is in single-user mode (see HMode).
The record is not locked.

Component : wd240hf.dll