Takes two parameters, FromIndex, ToIndex

Description:

Use this to keep only the specified Records in the Query based on their Record Index values. The primary use of this Statement is to limit results to a certain number of Records at a time for display purposes.

If To parameter is greater than the number of Records it will silently be adjusted to match the number of Records; no error will be generated.

Example:

KeepFor 5, 10