PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
New WINDEV, WEBDEV, WINDEV Mobile 25 feature!
  • Record number not specified
  • Data files in Hyper File 5.5 format
  • xBase files
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
<Source>.State (Function)
In french: <Source>.Etat
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
Used to find out the status of a record. A record can be active, crossed or deleted.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
IF Customer.State() = hStateActive THEN
// Processes
END
Syntax
<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 if it is equal to 0), <Source>.State handles the current record. The current record is not read again.
Remarks

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:
FileName.Read(hRecNumCurrent)
WEBDEV - Server codeHyper 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.
WEBDEV - Server codeAjaxNative 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 : wd250hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment