Karl: Think about it like this...we have an address book file with names in it and we create a customer file with a pointer to the address book entry in it. In order to get the customer name we "translate" into the address book. Now we index both the address book name and the "translated" customer name which creates two (2) separate indexes on the name: one in the address book directory and one in the customer directory.
Next we access the address book and change the name. When the address book record is updated the index routine deletes the old name from the address book index then adds the new name. Since there was no change to the customer record, that index _DOESN'T_ change. Hence, you've got two unsynchronized indexes. That's the problem noted. In order to correct this problem, the Customer record has to be updated to update its index. I don't believe U2 has an internal function to resolve this situation. You'll have to develop an application specific solution. Hope this helps. Bill > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Karl L Pearson > Sent: Friday, September 17, 2004 11:11 AM > To: u2-users > Subject: Re: [U2] UV: Indexing I-Descriptors > > 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 ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/