PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Position in relation to a key item or to a non-key item
  • Position in a filtered browse
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
HGetCurrentPosition (Function)
In French: HPositionCourante
ODBCNot available with this kind of connection
Returns the approximate position of current record in the data file. This position is given in relation to a specific item.
Note: The position is given approximately for performance reasons. The position is calculated according to the position in the index.
Versions 15 and later
Android This function is now available for the Android applications.
New in version 15
Android This function is now available for the Android applications.
Android This function is now available for the Android applications.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Example
HSeek(CUSTOMER, NAME, "Smith")
IF HFound(CUSTOMER) = True THEN
        Percentage is int = HGetCurrentPosition(CUSTOMER, NAME)/10
        Info("The first SMITH is at " + Percentage + "% of CUSTOMER on the NAME key")
END
Syntax
<Result> = HGetCurrentPosition([<File Name> [, <Item Name>] [, <Precision>]])
<Result>: Integer
  • Approximate current position, plotted to the [1;1000] interval.
  • -1 if an error occurs (empty data file, filter returning no result, ...). HErrorInfo returns more details about the problem.
<File Name>: Optional character string (with or without quotes)
Name of data file used. If this name is not specified, HGetCurrentPosition handles the last data file used by the last function for HFSQL management (starting with the letter H).
<Item Name>: Optional character string (with or without quotes)
Name of item used. If this name is not specified, HGetCurrentPosition handles the last item used by the last function for HFSQL management (starting with the letter H).
<Precision>: Optional integer
Defines the precision with which the position is evaluated. Caution: The higher the precision, the longer it takes to evaluate the position in the file.
hPrecisionLowLow precision.
hPrecisionMedium
(default value)
Medium precision.
hPrecisionHighHigh precision.
PHP This parameter is ignored.
Java This parameter is ignored. The calculation is always performed with a high precision.
Remarks
WINDEVWEBDEV - Server codeReports and QueriesiPhone/iPadWindows MobileUniversal Windows 10 AppPHPAjaxUser code (UMC)HFSQLHFSQL Client/ServerHyper File 5.5OLE DBNative Accesses

Position in relation to a key item or to a non-key item

For a key item, the position is relative to the order of record in the index of this item.
For a non-key item, the position is relative to the record number in the data file (see HRecNum).
WINDEVWEBDEV - Server codeReports and QueriesiPhone/iPadWindows MobileUniversal Windows 10 AppPHPAjaxUser code (UMC)HFSQLHFSQL Client/ServerHyper File 5.5OLE DBNative Accesses

Position in a filtered browse

If a filter with bounds is defined (HFilter without condition string but with lower and upper bounds), the returned position is relative to the records selected by the filter.
If a condition string is given to HFilter, the returned position ignores the filter.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment