On 09/11/10 20:47, George Gallen wrote: > I just created an Index on a fairly large file based on an I Desc. > > The IDESC is combination of Concatenating 5 TRANS()'d fields. > > After the index was built, it works great....but just curious, Will the > index get updated automatically, when the source file's data changes?
A GREAT BIG NO! > (remember, the index is based on TRANS'd data), Or > will I need to periodically rebuild the index, which in itself wouldn't be an > issue as the source file doesn't change very often. The index will get updated every time the record changes, but it won't know data in other files (the trans'd stuff) has changed. What you *might* be able to do, is every time a record in the source file changes, have a trigger-type routine (maybe in an index itself :-) that selects all the records in the target file that depend on that record, and does a quickie "read and write". That will ensure that the index will pick up all the records it should. What it will not do is ensure that it doesn't pick up records it shouldn't - because although the write will trigger a new entry in the new index, it won't be able to determine what the old entry was to remove it ... Cheers, Wol _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
