Bugs and PCs - Indexing 01 vs 1 [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Bugs and PCs - Indexing 01 vs 1=====

^Published By^Date^Version^Knowledge Level^Keywords^
|Sprezzatura Ltd|01 MAY 1989|1.13+|EXPERT|INDEXING, RIGHTDEX, BTREE, LOCATE|

Be aware that as both Rightdex and BTREE rely upon LOCATE BY "AR" the
numbers "01" and "1" will locate to the same place in the index and will
therefore be confused and one of the values will be lost in the index. This
means that any the missing key will still be on file but will not be found
by index lookups or by popups which use established Rightdexes.

The best way around this currently is to set up an edit pattern which simply
says IF NUM(@ANS) THEN @ANS = @ANS + 0. The act of adding 0 to the entered
value forces it to be evaluated as a number and thus strips off any leading
zeroes. (This does however mean that you cannot have 01 and 1 on file at the
same time).

Rating - Potentially dangerous as apparent data loss.


(Volume 1, Issue 1, Page 10)