RE: Trigger question

Since the trigger is after update, are you continuing to update the
record? It might be a candidate for a data queue process, and allow the
user to defer entering the additional data.

Loyd Goodbar
Business Systems
BorgWarner Shared Services
662-473-5713

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jones Simon
Sent: Thursday, June 12, 2008 9:47 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Trigger question

Hello all,

I have a trigger program which calls after an update to a database file,
that works fine.

A requirement has come up where some of the processing which is done by
the trigger program will need some user input by way of an interactive
screen. Instead of adding this screen to the trigger program I was
looking at adding a call to a new program from the trigger program. I'm
trying to work out if this will cause any problems - the trigger program
will be active for the duration of the time that the screen is displayed
and processed.

The obvious problem I've though of is the danger of trying to open the
display file in a batch job, but we can cater for this. But what I cant
work out is if this call to an intractive program will cause any issues
within the trigger program.

My initial thoughts are that this is likely to be a bad idea, but I'm
not really sure why!

Hopefully I've made that clear

Simon