ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Non-HFSQL data files
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
HRecNum (Function)
In french: HNumEnr
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
Returns:
  • the number of the current record in the HFSQL data file.
  • the number of the current record in the HFSQL view.
// Current record in the "Customer" data file
CurrentCustomerRec = HRecNum(Customer)
Syntax
<Result> = HRecNum([<Data file>])
<Result>: Integer
Corresponds to:
  • the number of the current record in the data file.
  • the number of the current record in the view or in the query (and not the number of the current record in the data file).
    Caution: Used on an HFSQL Classic view, this parameter does not correspond to the value of the H.NumRec variable.
  • the hInvalidRecNum constant if there is no current record (position outside the data file).
HError returns more details about the problem.
Hyper File 5.5 When used on a Hyper File 5.5 view, HRecNum returns the number of the current record in the data file associated with the view.
<Data file>: Optional character string
Name of HFSQL data file, query or view used.
If this parameter is not specified, HRecNum will use the last data file used by the last HFSQL management function (function starting with "H").
Remarks

Non-HFSQL data files

  • There is no record number on the data files.
  • The call to this function triggers a WLanguage error.
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help