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
<Source>.RecNum (Function)
In french: <Source>.NumEnr
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.
Example
// Current record in the "Customer" data file
CurrentCustomerRec = Customer.RecNum()
Syntax
<Result> = <Source>.RecNum()
<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, <Source>.RecNum returns the number of the current record in the data file associated with the view.
<Source>: Type corresponding to the specified source
Name of HFSQL data file, query or view used.
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 25
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/06/2023

Send a report | Local help