Home page Home page Home page Home page
Pixel
Pixel Header R1 C1 Pixel
Pixel Header R2 C1 Pixel
Pixel Header R3 C1 Pixel
Pixel

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.


0001    SELECT FILE BY FIELD :@VM : V1 : @VM : V2 SETTING CURSOR ELSE
0002      CALL FSMSG
0003      STOP
0004    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)
Pixel
Pixel Footer R1 C1 Pixel
Pixel
Pixel
Pixel