On Fri, 2004-09-17 at 11:10, Karjala Koponen wrote: > Karl, > > TRANS I descriptors are dangerous to index. > This should work fine when field 5 of BOHDR exists when the record you're going from > is written and field 5 of BOHDR does not change. > I don't know whether the I descriptor will be reviewed/renewed when the record > you're going from is rewritten, but I'd want absolute confirmation that the indexing > process does that. I'd be very nervous (assume) that the I descriptor is NOT > looked at again at a rewrite. > > The index will certainly be incorrect, however, when the field 5 of BOHDR is changed > after the record you're going from was last written because there is no reason for > the index to be updated. Triggers might be used to update the index in such an > event but I'd look for help elsewhere on this list for such guidance.
Okay, I'll bite... What you say leads me to believe that a TRANS I-Desc is dangerous because if the data changes in the remote file, then the index isn't updated and the data in the local file's index is out-dated, right? if that's the case, then doesn't that mean that the local file's index is holding all the data that is 'TRANS'ed from the other file? Isn't that NOT how an index works? I thought it just pointed to the attribute in the other file where it could look that data up. OR, is it that the stored procedure (TRANS I-Desc) might become different from the remote file's procedure if that DICT item is re-written/changed/removed, etc. ??? I'm a bit confused and would like some clarification... Perhaps what I've understood all these years has been superseded somehow/where. KLP > > Karjala > > > >>> [EMAIL PROTECTED] 09/17/2004 11:49:42 AM >>> > I just had an experience (UV 10.0.14, AIX 4.3.3) of indexing an > I-Descripted DICT item and than having a very important routine fall > down. > > Selecting against the TYPE I-Desc fails after being indexed and doesn't > before. > > I seem to remember a bug in this but hoped the bug had been solved... > > Here's the I-Desc: > 0001 I > 0002 TRANS(BOHDR,(ORDER.NUMBER),'5','X') > 0003 > 0004 ORD?TYP > 0005 2R > 0006 S > <0007... DELETED> > > Another thought: Is there a problem right justifying? Should it be left > (counter-intuitive from my perspective)? -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 888-972-3182 x29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
