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
Simple Security
QTIPS - Hiding Symbolic Source Code
Using One Dictionary With Multiple Tables - Aaron Kaplan - SoftMart Inc
Reader's Clinic - Scribe Replace Processes in Window
QTIPS - Make.Index 2.11+
RTP Series - RTP8
QTIPS - Make.Index 2.11+
Vroom
RTP Series - RTP32
Utility Diskette # 3 - Part I
@ATTACK - @Modal
RTP Series - RTP38
VERBatim - V124
Rebuilding Indexes
QTIPS - Make.Index 2.11+
Index Flush
Caching in on the Frames Array - Mike Pope
How Indexes Are Updated
QTIPS - Unexpected/Unwanted Modification Of Record On Write
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.
Creating Your Own Background Processes
@ATTACK - @Last.Select.Process
Reader's Forum
QTIPS - Menu Item Pre-Processing
SecureUser
VERBatim - V25
@ATTACK - @Files.System
Advanced Revelation Initialisation Sequence (Overview) by Mike Pope
REVMEDIA Revisted
Reader's Clinic - Page Marks in Windows

RevMedia FKB

DocumentV3I10A6
TitleQTIPS - Make.Index 2.11+
KeywordsMAKE.INDEX
DICT.MFS
%ALL.IDS%
WRITEV
INDEX.FLUSH
TextThanks to Michael Ruane of Phoenix Solutions Inc who pointed out that users
of the Make Index routine will be saddened to hear that as of release 2 11
direct CALLS are no longer necessary! The DICT MFS logic has been enhanced
to the degree that the simple act of updating dictionary records WITH the
appropriate index flag ensures that all appropriate index parameter records
are written This even covers the %ALL IDS% record to ensure that the new
index is built

Thus to add a Btree index all that is required is to WRITEV 1 to field 6 of
the appropriate dictionary item and then to call an INDEX FLUSH to ensure
that the index is rebuilt there and then Similarly to add an Relational
index all that is required is to write the FILE*FIELD*SORT_ORDER
information to field 23 of the appropriate dictionary item XREF dictionary
items still need to be created to support XREFed dictionary items though!

To remove an index just reverse the process WRITEV null to the appropriate
field the system will automatically take care of REMOVING the index
records


(Volume 3 Issue 10 Page 5)
[revmedia/copyrigh.htm]

Page last modified: 30/01/03