Relational Indexes (OpenInsight Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 02 JUN 1998 12:42:47PM Jeff Word wrote:

OpenInsight Specific

Example:

Table: COURSE

Column with index on it: YEAR

Table that actually holds the relational index: COURSE_YEAR_RX

Field in this table that actually holds the relational index: IDS

We delete a relational index on the COURSE table YEAR column.

Issue #1

In the DICT.COURSE_YEAR_RX table, IDS column, field 24 did not get cleared and field 25 is still 1.

We can still add the index back on even with this dangling piece left out there, however, all index "pieces" need to be removed to be clean.

Issue #2

The !COURSE_YEAR_RX table does not get deleted.

At 05 JUN 1998 11:14AM Cameron Revelation wrote:

Jeff,

I've forwarded this to Q/A. Do you know if this problem just appears on this one index or on any field of any file?

Cameron Purdy

info@revelation.com

At 05 JUN 1998 03:06PM Jeff Word wrote:

View this thread on the forum...