PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • Position in relation to a key item or to a non-key item
  • Position in a filtered iteration
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
Sets the position on a record, based on the approximate position of one of its items. The record is read.
This function can be used with the data files, HFSQL views or queries.
Caution: HSetPosition can only be used to set a position. To find out the current position, use HGetCurrentPosition.
Versions 17 and later
iPhone/iPad This function is now available for iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for iPhone/iPad applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Remark: 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.
Versions 22 and later
Android Widget This function is now available in Android widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for Java applications.
New in version 22
Android Widget This function is now available in Android widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for Java applications.
Android Widget This function is now available in Android widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for Java applications.
Example
HSetPosition(Customer, Name, 500)
Syntax
<Result> = HSetPosition(<Data file> [, <Item>] , <Position> [, <Precision>])
<Result>: Boolean
  • True if the positioning was performed,
  • False otherwise. HError returns more details about the problem. If no record corresponds, HOut returns True and no record is read.
<Data file>: Character string
Name of the data file, view or query used.
If this name is not specified, HSetPosition will use the last data file used by the last HFSQL function (function starting with "H").
<Item>: Optional character string
Name of the item used.
If this name is not specified, HSetPosition will use the last item used by the last HFSQL management function (function starting with "H").
<Position>: Integer
Approximate position to fix. This position must be found in the [1;1000] interval.
<Precision>: Optional integer
Defines the precision with which the position is performed. Caution: The higher the precision, the longer it takes to be positioned in the file.
hPrecisionHighHigh precision.
hPrecisionLowLow precision.
hPrecisionMedium
(default value)		Medium precision.
Remarks

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 the record in the index of this item.
  • For a non-key item, the position is relative to the number of the record in the data file (see HRecNum).

Position in a filtered iteration

If a filter with bounds is defined (HFilter without condition string but with lower and upper bounds), the position is relative to the records selected by the filter.
If a condition string is given to HFilter, the position ignores the filter.
Component: wd270hf.dll
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment