In order for this site to work correctly, and for us to improve the site, we need to store a small file (called a cookie) on your computer.
By continuing to use this website, you agree to our cookies and privacy policy.
  
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