RE: Triggers

["Stone, Brad V (TC)" <bvstone@xxxxxxxxxxxxxx>]

> -----Original Message-----
> From: boothm@ibm.net [SMTP:boothm@ibm.net]
> Sent: Saturday, August 22, 1998 12:36 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      Triggers
> 
> When one puts a trigger on a physical file:
> 
> 1-Does the trigger get copied to copies or duplicated objects of the
> triggered file?
        [And Brad Said:]  Yes 
> 2-What happens if a field is accessed/changed with a non-green screen
> application like Access if the trigger validates a field, and if
> invalid,
> starts an interactive window displaying valid choices?  (There is a
> file
> that is used in a very elaborate and integrated purchased package.  We
> want to validate a few fields in the file against acceptable responses
> in
> another file.  A trigger does that very nicely.  We don't access the
> file
> with any non-green screen applications now, nor do we plan to, but we
> are
> wondering what would happen if the future changed our mind.)
        [And Brad Said:]  It will try to display the screen.  Most
likely causing an I/O error or something similar.
        Triggers do validate nicely, but I'm not sure this is the best
application for them.  Why not validate before the update? 
> tia
> 
> -- 
> -----------------------------------------------------------
> boothm@ibm.net
> Booth Martin
> -----------------------------------------------------------
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---