QTIPS - Extended Select Syntax

Pat McNerthney of Icicle Software in the user guide to BondTRV documents a feature of the extended select syntax which provides access to a range within a sorted index without using the REDUCE functionality.

  SELECT FILE BY FIELD :@VM : V1 : @VM : V2 SETTING CURSOR ELSE
    CALL FSMSG
    STOP
  END

V1 is the starting value of the select - if blank the select will start at the beginning of the index. If a value is specified the select will begin at the first value >= V1.

V2 is the ending value of the select - if blank the select will continue to the end of the index. If a value is specified the select will continue with all values <= V2.

(Volume 3, Issue 6, Page 8)