Hi All

I am surprised to be writing this as the issue I am raising has previously worked correctly with same version of OI. (7.1.1)

I have a Table B, with a Relational Index going to Table A. The Source Field and the Destination Key, and the Destination Field are all VARCHAR.

When the Target Key is 0 (zero), (not null, but a numeric 0), the Destination Field is not updated with the Source Key. The target record 0 does exist.

Thanks in advance for your thoughts.

Cheers

Robert

Well in 8.01 the Database Manager has a setting "Update 0 keys on related indexes". Over a year ago in the Works section Karen Oland asked "Is it possible that RTI could fix the code for relational indexes in OI to properly maintain these in the case of records with a zero key ("0") - perhaps fixing the logic that skips the write from "if key" to "if len(key)" (or something similar)?" - so it would seem to have been a known bug that has been fixed.

The Sprezzatura Group

World leaders in all things RevSoft

Hi Sprezz

Thanks for that. Very curious. It definitely used to work…

R

View this thread on the forum...