PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

  • 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
Positions on a record from 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 be positioned. To find out the current position, use HGetCurrentPosition.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
HSetPosition(Customer, Name, 500)
Syntax
<Result> = HSetPosition(<File name> [, <Item name>] , <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.
<File name>: Character string (with or without quotes)
Name of data file used.
If this name is not specified, HSetPosition 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, HSetPosition handles the last item used by the last function for HFSQL management (starting with the letter 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.
hPrecisionLowLow precision.
hPrecisionMedium
(default value)
Medium precision.
hPrecisionHighHigh 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 browse

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 : wd250hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment