What's the best way...

Deskin, Bob Bob.Deskin@Cognos.COM
Thu, 18 Mar 1999 06:26:18 -0500


Unfortunately if you want to use ASC or user class, it's going to be
procedural. At least I haven't seen any other way to do it within the same
screen (notwithstanding conditional compiles and recompiling screens).

However, there are lots of ways to approach the restriction code. Depends
how nice you want to be to your users. If they know they're not supposed to
change things, then you could put a reminder message out in the POST FIND
procedure based on ASC/USER and then test in the PREUPDATE procedure. I
don't like changing the UPDATE procedure unless I'm really forced to. And
especially for errors. If you don't even want them to be prompted, then
you'd have to change the numbered DESIGNER procedures that pormpt for
changes. Don't forget the MODIFY procedure as well if it's available. To
disable Entry, use the PREENTRY procedure. I'm assuming you're using a
series 7 or 8 version that has all these procedures.

This sort of need doesn't come up very often which is why we don't have mode
based security. It's been a nice to have but not a killer.

Bob Deskin              
Senior Product Advisor, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 4205 FAX: (613) 228-3149
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA


-----Original Message-----
From: John Pearce [mailto:jpearce@rmi.net]
Sent: Wednesday, March 17, 1999 11:11 PM
To: powerh-l@lists.swau.edu
Subject: What's the best way...


What's the best way to have a single screen serve two sets of users (based
on user class) where one user class can do everything (enter, update,
delete) and the other user class can only inquire on existing records?

If, for example, I put procedure code into the UPDATE procedure to check
the user class, the inquiry users will be able to make changes on the
screen yet the update will fail.  Since this approach requires procedure
code in several procedures, the code and its maintenance may be more
trouble that having two sets of screens.

What am I missing???  Is there a better way to accomplish this???  Running
8.19C3 on HP.



------------------------------------------------------------------
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.