George:
The answer, in short, is /*no*/! You'll have to periodically rebuild the
index.
In our application we have a single address book. An entry could be
associated with an A/R customer, an A/P vendor, a P/R employee, a
property's unit, and a few other entity type records. When the user
modifies the name, the address book's index is updated immediately but
the subsidiary table's index is not (e.g. the A/R customer).
We have a utility that runs upon every login to reindex the subsidiary
tables that have been changed. This rebuilding is frequent enough for
our purposes but you'll have to decide what frequency is appropriate for
your environment. We tried to create a trigger routine that works but
kept running into a deadly-embrace situation, so we gave up (at least I
did). Maybe someone else has something like this working they'd like to
share with all of us.
HTH,
Bill Haskett
* / Advantos Systems, Inc./ *
4370 La Jolla Village Drive, Suite 400
San Diego, CA 92122
☎ Tel: 360-464-2773 (WA) | ☏ Fax: 760-944-7743
"What Software can be."
------------------------------------------------------------------------
George Gallen said the following on 11/9/2010 12:47 PM:
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?
(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.
This is on UV.
George
George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
