Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- FiveWin 1.9.2 - January 97 - <b>cfield</b> select clause expression in select ... for ... to ... http://www.ousob.com [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 cField          SELECT clause expression in SELECT ... FOR ... TO ...
--------------------------------------------------------------------------------

 FiveWin implements a powerful system based on indexes to simulate subindexes
 when working with standard NTX indexes.

 If you are using Comix or SixDriver then you should use those drivers
 ...SetScope( ... ) functions as they are faster and more efficient. But if
 you need to keep working with standard NTX files, then the FiveWin scope
 system will help you avoiding a lot of work on your side.

 Imagine you have a Customer DataBase indexed by Last + First names, and
 you want to review just customers from 'D' up to 'L'. Clipper does not
 offer you a way to do it (except using Comix or SixDriver), lets see how
 you may browse only those customers with FiveWin:

       REDEFINE LISTBOX oBrw ;
          FIELDS Customer->Last, Customer->First ;
          HEADERS "Last", "First" ;
          ID ... OF oDlg ;
          SELECT Customer->Last + Customer->First FOR "D" TO "L"

 Remember that SELECT must be based on the active index of the used DataBase.
 FiveWin does a SEEK of the FOR clause expression, and checks on each
 SKIP that the current record matches the SELECT expression specified.

 If you don't specify the TO clause, then FiveWin will keep skipping
 while the FOR clause is matched. i.e.: In the above sample if you only
 specify the FOR "D", FiveWin will skip up to the "E" which follows the
 "D".

 Have a look at SAMPLES\FwBorl2.prg for a working sample.

 You may dynamically change the current selection set to your browse.
 See the explanation for :Select() METHOD in this section also.


Online resources provided by: http://www.ousob.com --- NG 2 HTML conversion by Dave Pearson