QTIPS - Btree.Extract
Comp
Reader's Clinic - Removing "Searching Cross References" Message
@ATTACK - @List.Active
IConvs / OConvs
Reader's Clinic - Stop Lists
REVMEDIA Revisited
REVMEDIA Revisited
@ATTACK - @Return.Value
Vroom
RTP Series - RTP32
Utility Diskette # 3 - Part I
QTIPS - Break-On Date Fields
IConvs / OConvs
QTIPS - DOS File Names
DOS Interfacing (Part II)
VERBatim - V116
@ATTACK - @Pri.File
@ATTACK - @Rollout.File
File Variables
How Indexes Are Updated
Index Record Layouts
QTIPS - File Variable of File In SELECT Statement
QTIPS - Amending non-Attached Files
LINEAR HASH FILE STRUCTURES - Part 1
Index Flush
QTIPS - File Handle Structure
Make.Index
QTIPS - Btree.Extract
!File Records
Index Sub Revisited
QTIPS - Stop Lists
Reader's Clinic - Stop Lists
Utility Diskette # 4
QTIPS - Manipulating XREF formulae.
QTIPS - Btree.Extract
Uncommon Knowledge - WC_VWindow%
!File Records
QTIPS - Updating Indexes
Indexing on Xlates
Rebuilding Indexes
How Indexes Are Updated
Index Record Layouts
Index Flush
REVMEDIA Revisited
Reader's Clinic - Page Marks in Windows

RevMedia FKB

DocumentV1I4A2
TitleQTIPS - Btree.Extract
KeywordsBTREE.EXTRACT
XREF.PARAMS
TextWhen USING BTREE EXTRACT it can be useful to get at all those records
WITHOUT a value in a field For EXAMPLE you may wish to extract all
employees for whom the date of birth is not on file Or conversely you may
wish to get at all those employees who have been to University

Calling BTREE EXTRACT WITH XREF PARAMS set to ="" or #"" does not work
Instead the syntax <="" and >"" must be used E G

PARAM ="DOB":@VM:"<=' ' ": @FM

or

PARAM = "UNI":@VM:">' ' ":@FM


(Volume 1 Issue 4 Page 3)
[revmedia/copyrigh.htm]

Page last modified: 08/02/03