EPUB | CHM | PDF

TPSQLTable.Methods.SetRange

Top Previous Next

Sets the starting and ending values of a range, and applies it.

Syntax:

procedure SetRange(
  const StartValues, EndValues: array of const);

Description:

Call SetRange to specify a range and apply it to the dataset. StartValues indicates the field values that designate the first record in the range. EndValues indicates the field values that designate the last record in the range.

SetRange combines the functionality of SetRangeStart, SetRangeEnd, and ApplyRange in a single procedure call. SetRange performs the following functions:

      • Puts the dataset into dsSetKey state.
      • Erases any previously specified starting range values and ending range values.
      • Sets the start and end range values.
      • Applies the range to the dataset.

If either StartValues or EndValues has fewer elements than the number of fields in the current index, then the remaining entries are set to NULL.