ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Non-HFSQL data files
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
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>: entier
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).
    Warning When 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: wd300hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 12/07/2024

Send a report | Local help