HState (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Record number not specified

Data files in Hyper File 5.5 format

xBase files

See also

ExecuteQueryAsynchronous

ExecuteSQLQueryAsynchronous

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HExecuteQuery

HExecuteQueryAsynchronous

HExecuteSQLQuery

HExecuteSQLQueryAsynchronous

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

This content has been translated automatically. Click here to view the French version.

Record number not specified
Data files in Hyper File 5.5 format
xBase files

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HState (Function)

In french: HEtat

Available only with these kinds of connection

Used to find out the state of a record. A record can be active, crossed or deleted.

Versions 18 and later

This function is now available in Windows Store apps mode.

New in version 18

This function is now available in Windows Store apps mode.

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

Versions 19 and later

This function is now available for Java applications.

New in version 19

This function is now available for Java applications.

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.

Example

See additional examples

IF HState(Customer) = hStateActive THEN
// Processes
END

Syntax

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

<Result>: Integer constant

Status of record:
hStateActive The record is active.
hStateInvalid Record status not found (error).
hStateCrossed The record is crossed.
hStateDel The record is deleted.

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

Name of data file used. If this name is not specified, HState will use the last data file used by the last HFSQL management function (function starting with "H").

<Record number>: Optional integer

Number of the sought record. If this number is not specified (or is equal to 0), the function HState will handle the current Record. The current record is not read again.

Remarks

Record number not specified

HState reads no record if <Record number> is not specified.

In a network application, we advise you to read the record again before the call to HState to make sure that the record was not deleted. With HRead for example:

HRead(FileName, hRecNumCurrent)

Data files in Hyper File 5.5 format

With the Hyper File 5 engine, the record must be read again in order for its status to be refreshed. Indeed, if the record is not read again after HDelete or HCross, HState always returns hStateActive.

This operating mode is no longer available in the HFSQL Classic engine. Once HDelete or HCross was used on the current record, HState returns the current record status.

xBase files

HDelete and HCross have the same effect: the record is crossed but it is not deleted. Therefore, the record can be re-enabled by HModify.

In this case, HState returns the hStateCrossed constant for a deleted record (instead of hStateDel).

Component: wd260hf.dll