|
|
|
|
|
|
|
|
|
|
- Position in relation to a key item or to a non-key item
- Position in a filtered iteration
<Source>.SetPosition (Function) In french: <Source>.Positionne
 Not available with this kind of connection
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.
Customer.SetPosition(name, 500)
Syntax
<Result> = <Source>.SetPosition([<Item>, ] <Position> [, <Precision>])
<Result>: Boolean - True if the positioning was performed,
- False otherwise. HError returns more details about the problem. If no record corresponds, <Source>.Out returns True and no record is read.
<Source>: Type corresponding to the specified source Name of data file, view or query used. <Item>: Optional character string Name of the item used.
If this name is not specified, <Source>.SetPosition 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. | | | hPrecisionHigh | High precision. | | hPrecisionLow | Low 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 <Source>.RecNum).
Position in a filtered iteration If a filter with bounds is defined ( <Source>.Filter 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 <Source>.Filter, the position ignores the filter.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|