| Reader's Clinic - Fixing %Windows% Using Depend.Update |
| QTIPS - Updating Indexes |
| How Indexes Are Updated |
| REVMEDIA Revisted |
| Network Contention |
| Index Sub Revisited |
| Rebuilding Indexes |
| Utility Diskette # 3 - Part I |
| Utility Diskette # 4 |
| QTIPS - DOSTime |
| VERBatim - V11 |
| @ATTACK - @Backgrnd.Time |
| @ATTACK - @Index.Time |
| QTIPS - Time-outs in Windows |
| 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. |
| Simple Security |
| QTIPS - Hiding Symbolic Source Code |
| Using One Dictionary With Multiple Tables - Aaron Kaplan - SoftMart Inc |
| Argument passing - Subroutines and Functions - Mike Pope |
| Caching in on the Frames Array - Mike Pope |
| QTIPS - Fast Dynamic Array Building |
| Version 2 |
| Bugs and PCs - Xlate with Multipart Keys |
| RTP Series - RTP16 |
| SecureUser |
| Indexing on Xlates |
| Reader's Clinic - Slow Multivalued Screen Display |
| Caching in on the Frames Array - Mike Pope |
| @ATTACK - @Default.Stops |
| QTIPS - Stop Lists |
| Reader's Clinic - Stop Lists |
| QTIPS - Default Stop Lists |
| QTIPS - Manipulating XREF formulae. |
| 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 |
RevMedia FKB
| Document | V2I7A1 |
| Title | Reader's Clinic - Stop Lists |
| Keywords | STOP LIST XREF BTREE.EXTRACT |
| Text | Gareth Hardy of Chilworth Communications recently faxed in relation to the GO LIST tip in issue 5 "The problem is I need to update the go list quite frequently and yet I don't want to have to rebuild that index each time a change is made A complete list of codes is held on a parameters file elsewhere Any ideas?" When an XREF index is added to a field a new dictionary item is created with the suffix ' XREF' and this item CALLS the routine XREF to dynamically parse the array into multi values USING the specified delimiter list EG with a normal GO list (CALL omitted) XREF({TEXT} \20\ LIST "4") where LIST was actually "ABC1" : @VM : "ABC2" : @VM : "ABC3" This could just be modified to read LIST=XLATE("PRMS" "GO" "" "X") XREF({TEXT} \20\ LIST "4") or whatever the parameters file is called ie Xlate the go list at run time This works but remember the caveat that as the list is changed ONLY NEW ENTRIES will reflect this new list In other words previously indexed records will not be indexed on the new GO words until the index is rebuilt !WARNING! Remember when USING STOP lists BTREE EXTRACT is not aware of their existence If INC is in the STOP list and the user asks for ACME INC the system will get hits for ACME but get no hits for INC It will AND the two lists and decide that there are no occurrences of ACME INC It is best to avoid STOP lists unless you are sure that this will not happen to you OR modify all CALLS to BTREE EXTRACT to remove the STOP words (Volume 2 Issue 7 Page 3) |
Page last modified: 08/02/03