I kind of like the logical idea, but then you'd have to change the existing
programs that need the records with the ferpa data to adopt authority.

As far as triggers...
If you put a before read trigger on the file and set it to fail, what
happens to Query, et. al.?  Does it ignore the record or does it throw a
hissy fit?

Rob Berendt
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin

                    "Booth Martin"
                    <booth@MartinVT.com       To:     "midrange-l@midrange.com" 
                    >                         cc:
                    Sent by:                  Fax to:
                    midrange-l-admin@mi       Subject:     Use of a trigger...? 
 is this areasonable?

                    01/23/2002 12:20 PM
                    Please respond to

I've just been handed a problem and first blush tells me that a trigger is
the answer, but I sure would like to hear comments from people on the list
that have already dealt with this sort of problem.

Here's the deal:  our name and address file has a field in their for FERPA.
If its marked then the name can not be listed or generally distributed
without that person's written permission.   This has worked fine for years
when we only accessed the information with our RPG programs.

Now though we have users with Query and other methods of accessing the
and these users just ignore the FERPA field.  The results are labelled
Trouble waitng to happen".

What ways would you folks offer as ways to prevent access to that record if
FERPA is chosen?  (I'm thinking this is a question all of us are facing

Booth Martin
802-454-8315 x235
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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.