<Source>.SetPosition (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

Position in a filtered browse

ErrorStatusModification

FilterIncludedBetween

MigrateLinkedCompositeKey

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

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<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.

Caution: <Source>.SetPosition can only be used to be positioned. To find out the current position, use <Source>.GetCurrentPosition.

Versions 17 and later

This function is now available for iPhone/iPad applications.

New in version 17

This function is now available for iPhone/iPad applications.

Versions 18 and later

This function is now available in Windows Store apps mode.

New in version 18

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

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Versions 22 and later

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

New in version 22

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

Example

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 (with or without quotes)

Name of item used.
If this name is not specified, <Source>.SetPosition will use the last data file 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.
hPrecisionLow Low precision.
hPrecisionMedium
(default value) Medium precision.
hPrecisionHigh High 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 browse

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.

Component: wd260hf.dll