Home | Sign in | English EN

  • Record number not specified
  • Data files in Hyper File 5.5 format
  • xBase files
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Stored procedures
<Source>.State (Function)
In french: <Source>.Etat
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
Used to find out the state of a record. A record can be active, crossed or deleted.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 19 and later
Java This function is now available for Java applications.
New in version 19
Java This function is now available for Java applications.
Java This function is now available for Java applications.
IF Customer.Report() = hStateActive THEN
// Processes
<Result> = <Source>.State([<Record number>])
<Result>: Integer constant
Status of record:
hStateActiveThe record is active.
hStateInvalidRecord status not found (error).
hStateCrossedThe record is crossed.
hStateDelThe record is deleted.
<Source>: Type corresponding to the specified source
Name of data file used.
<Record number>: Optional integer
Number of the sought record. If this number is not specified (or is equal to 0), the function <Source>.State will handle the current Record. The current record is not read again.

Record number not specified

<Source>.State 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 <Source>.State to make sure that the record was not deleted. With <Source>.Read for example:
Hyper File 5.5

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 <Source>.Delete or <Source>.Cross, <Source>.State always returns hStateActive.
This operating mode is no longer available in the HFSQL Classic engine. Once <Source>.Delete or <Source>.Cross was used on the current record, <Source>.State returns the current record status.
Reports and QueriesUser code (UMC)AjaxNative Connectors (Native Accesses)

xBase files

<Source>.Delete and <Source>.Cross have the same effect: the record is crossed but it is not deleted. Therefore, the record can be re-enabled by <Source>.Modify.
In this case, <Source>.State returns the hStateCrossed constant for a deleted record (instead of hStateDel).
Component: wd260hf.dll
Minimum version required
  • Version 25
This page is also available for…
Click [Add] to post a comment