What's the best way...

[Michael Lee]

There is another better method to doing this that I used on an application in
Toronto. The only problem is that it will affect the whole application and
really should be used from the beginning of development. As well it was used on
an AS/400 which has a modify procedure. It is as follows:

First we changed the QKGO to Upshift actions and changed the actions for things
like 'Entry', 'Modify', 'Update', etc. to lowercase values. We then created a
USE file with procedure designer E (for Entry), procedure designer M (for
modify), procedure designer 'U', 'US', 'UN' (for updates). We then added code
to check the security files when the users tried to access these procedures and
gave errors (if required) accordingly.  It worked like a charm, but has to be
done for the entire application at the beginning. As well if you are not on the
AS/400 you do not have a 'modify' procedure which would complicate things. The
only other issue was when they were in help they saw these lowercase e's, m's
and various u's. It wasn't a big issue though.


Michael Lee
MCL Systems Inc.


John Pearce wrote:

> I didn't realize the level of discussion my question would generate!!!
> Thanks for all the responses.
>
> Thanks, also, to Bob Deskin for submitting the suggestion to add ASC
> class(es) to the Activities list.  That is certainly a better solution than
> procedure code. Hopefully the development people will get it in the product
> before I retire! :-)
>
> To those that said I should modify the PREupdate procedure, you are
> correct.  My fingers and brain weren't in sync when I typed UPDATE.  I am a
> graduate of the "Matt Ohmes PowerHouse School" (Hi, Matt!) and so I don't
> touch the UPDATE procedure unless there is no other way.
>
> ------------------------------------------------------------------
> John Pearce  <jpearce@rmi.net>       | Bethesda Management Company
> Speaking for only myself             | Colorado Springs, CO  USA
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.