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. 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/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
