RTP Series - RTP57
File Variables
Reader's Clinic - Volume Pointer Record
REVMEDIA Revisted
Utility Diskette # 4
RTP Series - RTP1
VERBatim - V20
File Variables
Form.List.S
Make.Index
Index Sub Revisited
QTIPS - Make.Index 2.11+
QUERY.SUB
Version 3 Technical Highlights - Creating New Accounts Programmatically
Version 3 TCL Subroutines - Creating New Accounts
Version 3 TCL Subroutines - Creating Tables
Redefining Keys
RTP Series - RTP53B
Prompt Help
VERBatim - V124
Popups
@ATTACK - @Environ.Set
@ATTACK - @Edit.Keys
@ATTACK - @Int.Const
@ATTACK - @HW
@ATTACK - @Modal
@ATTACK - @Move.Keys
@ATTACK - @Priority.Int
@ATTACK - @Macro.Mode
Utility Diskette # 3 - Part I
Utility Diskette # 3 - Part II
Utility Diskette # 4
Utility Diskette # 3 - Part I
Utility Diskette # 3 - Part II
Utility Diskette # 4
Bugs and PCs - Indexing 01 vs 1
VERBatim - V77
Index Sub Revisited
Indexing on Xlates
Advanced Revelation Initialisation Sequence (Overview) by Mike Pope
Simple Security
Batch.Indexing
QTIPS - Batch.Indexing Close Down
What's New (and un(der)documented!) In 2.12
Playing with Scan Codes
QTIPS - Compiling Protection Code
QTIPS - Invalid Code and Command
QTIPS - Code/Command Help
Compiling 64K on a Shoestring by Blaise Wrenn (LexStat Systems Ltd)
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.
@ATTACK - @Modal
SecureUser
VERBatim - V25
@ATTACK - @Files.System
Advanced Revelation Initialisation Sequence (Overview) by Mike Pope
REVMEDIA Revisted
Simple Security
QTIPS - Hiding Symbolic Source Code
Using One Dictionary With Multiple Tables - Aaron Kaplan - SoftMart Inc
Vroom
RTP Series - RTP32
Utility Diskette # 3 - Part I
Utility Diskette # 4
Version 3 Technical Highlights - Creating New Accounts Programmatically
Version 3 Technical Highlights - Securing Accounts
Version 3 Technical Highlights - Deleting Accounts
Version 3 TCL Subroutines - Creating New Accounts
Version 3 TCL Subroutines - Deleting Accounts
Reader's Clinic - Functions and Subroutines
Argument passing - Subroutines and Functions - Mike Pope
Redefining Keys
Background Processing
Reader's Clinic - Prompting for Passwords
Capture
Creating Your Own Background Processes
@ATTACK - @Edit.Keys
@ATTACK - @Index.Time
@ATTACK - @PlayBack
@ATTACK - @Priority.Int
How Indexes Are Updated
A RevTechie Replies - And Miscellaneous Jottings - Mike Pope - Revelation Technologies (UK) Ltd
QTIPS - Use of Mouse
QTIPS - Interrupt Proof Error Messages
Uncommon Knowledge - WC_Soft_Keys%
A RevTI Techie Replies - Mike Pope - Revelation Technologies (UK) Ltd
Version 3 Technical Highlights - Input.Char
Version 3 Technical Highlights - @Prog.Char
Version 3 Technical Highlights - Highlight
VERBatim - V39
VERBatim - V122
VERBatim - V123
Index Sub Revisited
@ATTACK - @Sentence
@ATTACK - @Rollout.File
QTIPS - File Variable of File In SELECT Statement
Reader's Clinic
Reader's Clinic - Template Name at Pre-Init
QTIPS - Replacing GAS.BAR routine during PERFORM "SELECT"
QTIPS - Suppressing Initial Form Feed
File Variables
LINEAR HASH FILE STRUCTURES - Part 1
QTIPS - File Handle Structure
Index Sub Revisited
@ATTACK - @Pseudo
QTIPS - Browse Lists in Collector Windows
QTIPS - NoRead
QTIPS - Using @Upper.Case and @Lower.Case with Foreign Languages
@ATTACK - @Lower.Case
@ATTACK - @Upper.Case
Sorting out Collation Sequences by Mike Pope
QTIPS - Menus Without an Action Bar
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
Reader's Clinic - Page Marks in Windows

RevMedia FKB

DocumentV2I4A2
TitleIndex Sub Revisited
KeywordsINDEX.SUB
MAKE.INDEX
XREF
REBUILD
INDEXING
@PSEUDO
@SENTENCE
TextOne of the most popular articles in Volume 1 of REVMEDIA was that explaining
the use of the undocumented routine MAKE INDEX to manipulate INDEXES on
files The first utility diskette contained a routine called INDEX SUB which
used MAKE INDEX and INDEXING to simplify all handling of INDEXES

With the release of 2 0 RevTech have changed the way in which both of these
routines work This article reflects these changes and explains how to
modify the INDEX SUB code to cope WITH the new release

Adding XREF Indexes
Whilst the old "A" call to add XREF INDEXES seems to work an index rebuild
does not work on an XREF index created in this manner This is because
RevTech have rationalised the way in which the system treats symbolic
btrees Whereas previously the XREF dictionary item did not require a flag
in field six indicating that it was btreed version 2 0 insists that this be
present Thus the MAKE XREF DICT portion of INDEX SUB must be modified to
take account of this as follows

MAKE XREF DICT:
DICT REC = "S"
DICT REC<3> = ITEM : " XREF"
DICT REC<4> = "M"
DICT REF<6> = 1 < NEW!!
DICT REF<8> = "CALL XREF( (as before)
DICT REF<9> "L" : @FM : 10
RETURN


Rebuilding Indexes
The INDEXING subroutine has been modified so that it looks for its input in
@PSEUDO rather than in @SENTENCE The structure of @PSEUDO must be

@PSEUDO<1>= FILENAME
@PSEUDO<2>= ITEMNAME
@PSEUDO<3>= B for BTREE
C for Cross Reference
R for Relational

The relevant sections of INDEX SUB should be modified as follows

CASE ACTION = "B"
*Rebuild a btree
@PSEUDO = FILE : @FM : ITEM : @FM : "B"
OR
*Rebuild an XREF
@PSEUDO = FILE : @FM : ITEM : @FM : "C"
OR
*Rebuild a relational
@PSEUDO = FILE : @FM : ITEM : @FM : "R"
CALL INDEXING ("TCL")


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

Page last modified: 30/01/03