I have noticed a problem with some of our indexes. We have TABLE_1 and TABLE_2. TABLE_1 has a dictionary item NAME. NAME has a cross-reference index on it. TABLE_2 has a calculated column in it T1_NAME. T1_NAME uses XLATE to retrieve NAME from TABLE_1. T1_NAME has a btree index.

The problem we have noticed if TABLE_1 has a record where NAME is Smith. If we Delete the record from TABLE_1, and then UPDATE_INDEX(TABLE_1,,) TABLE_1 indexes are updated correctly. The problem is with TABLE_2. We noticed that RLIST would still return the KEY of the record that was linked to TABLE_1 with smith, even though it had been deleted. So in an attempt to correct the problem we also added UPDATE_INDEX(TABLE_2,,) to the program. This did not solve the problem. The only way we can get a query on TABLE_2 requesting T1_NAME=smith" to not contain the key we deleted is to completely rebuild the index on TABLE_2 rather than updating it.

We are using OI 3.2. Have we set these indexes incorrectly?

Any assistance is appreciated.

Matt Bavis

Electronic Registry Systems, Inc.

Matt,

Your indexes are working fine. The issue would be that the problem value is a symbolic - the index does not know that you have changed the 'real' data thus requiring reprocessing of the symbolic. The only way thus is to rebuild….. (On a form, if the symbolic is resident on the form with the data field I think it triggers an index update - but I would need to verify this.) This is problem of 'dependancy' is clearly doc'ed in OI. However you can modify the Dict record of the symbolic to establish a dependancy. The method has been doced in Sprezzatura's Revmedia.

Richard

Thanks Richard.

Matt Bavis

View this thread on the forum...