Btree index failure (OpenInsight 32-Bit) [Revelation On-Line Wiki]

OpenInsight 32-Bit, Chris Meyer, //www.sprezzatura.com]The Sprezzatura Group[/url]

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 25 FEB 2011 06:32:31AM Chris Meyer wrote:

If a field is btree indexed with say 3 as the data. Then if the data is changed to 0003 the index is not updated and a wrong subsequent selection. Indexes need to be rebuilt before correct listing/selection takes place.

At 25 FEB 2011 08:23AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:

You could probably gen the !! code and modify the comparison to be if value : "X" # oldValue : "X" to force a string comparison rather than a numeric comparison.

The Sprezzatura Group

The Sprezzatura Blog

World leaders in all things RevSoft

View this thread on the Works forum...