Re: Anyone using the *AFTER *READ Triggers in V5R1/V5R2?

You can even do some nice things with a traditional SQL View.   The CASE
statement would allow the users to see a meaningful value returned like
'ACTIVE'
or 'InACTIVE'    instead of the real values of the field (like   '0'  or
'1').

CREATE VIEW clearview
As Select
Ordno,
CASE  Status
When 'O'  Then 'Open'
When 'C'  Then 'Closed'
End
AS Status

or even more complicated ones with arithmatic functions against fields in
the record.

John Carr

------------------------------------


Mark:

It seems to me you'd be better off implementing views that return UDF
values for the columns in question.

Tom Liotta




                    qsrvbas@netscape.ne
                    t (Tom Liotta)             To:     midrange-l@midrange.com
                    Sent by:                   cc:
                    midrange-l-admin@mi        Subject:     Re: Anyone using 
the *AFTER *READ Triggers in V5R1/V5R2?
                    drange.com


                    11/25/2002 02:55 PM
                    Please respond to
                    midrange-l






Mark:

It seems to me you'd be better off implementing views that return UDF
values for the columns in question.

Tom Liotta

midrange-l-request@midrange.com wrote:

>   1. Re: Anyone using the *AFTER *READ Triggers in V5R1/V5R2? (Mark
Waterbury)
>
>But, from my point of view, what I want to do is to be able to
>implement some 'business rules' in which the actual data returned
>to the calling program may be different, depending on some "rules".

--
--
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertechgroup.com


__________________________________________________________________
The NEW Netscape 7.0 browser is now available. Upgrade now!
http://channels.netscape.com/ns/browsers/download.jsp

Get your own FREE, personal Netscape Mail account today at
http://webmail.netscape.com/
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.