×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
As others have said, asking for user interaction in a trigger program
is not the best solution.
If you need to update a field in a lot of places, have the program
that discovers the need place the needed information (including the
extra piece you were going to ask for) in a data queue (as a single
'field' (ie data structure)). Then, the program needs to check and
see if a Never Ending Program is running-- if not, start it.
The Never Ending Program will receive transactions from the data
queue and update all of the places that need to be updated.
Is the field that needs to be changed by any chance a key field? If
so, this is looking -very- yucky no matter how you slice it!
One problem with a trigger program trying to get information from a
user is that the user may have gone to lunch. And the record in
question will be tied up until that user decides to respond.
--Paul E Musselman
PaulMmn@xxxxxxxxxxxxxxxxxxxx
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
