HUnlockRecNum (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

ExecuteQueryAsynchronous

ExecuteSQLQueryAsynchronous

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HExecuteQuery

HExecuteQueryAsynchronous

HExecuteSQLQuery

HExecuteSQLQueryAsynchronous

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).

Remark: 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 Java applications.

This function is available for 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 Java applications.

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

This function is now available for Java applications.

This function is available for 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 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 Android Widget mode.

This function is now available for Android applications (for 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 Android applications (for 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 Android applications (for 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.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Example

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

Syntax

<Result> = HUnlockRecNum([<Data file> [, <Record number>]])

<Result>: Boolean

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

<Data file>: Optional character string (with or without quotes)

Name of data file used.
If this name is not specified, the function HUnlockRecNum will handle the last data file used by the last HFSQL management function (function 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 hRecNumCurrent 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 hRecNumCurrent constant).

Remarks

HUnlockRecNum has no effect if:

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

Component: wd260hf.dll