QTIPS - Extended Select Syntax [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== QTIPS - Extended Select Syntax=====

^Published By^Date^Version^Knowledge Level^Keywords^
|Sprezzatura Ltd|01 NOV 1991|2.1+|EXPERT|SELECT|

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.

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

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)