<Craig>
'm not sure I agree - I think I CAN control the environment:
I'm using the LIBRARY on the trigger buffer. That tells me unequivocally
which library the file is in.
All my triggers run in a named activation group.
I am overriding all file access using an activation group override which I
remove at the end of the trigger.
The overrides specify Secure( *Yes )
I can't at the moment see why this wouldn't work - do you think there is a
problem?
</Craig>
... I did overlook that you have the library in the trigger buffer, I'm no
friend of override operation, there could be an override at job level, ore
some other strange things - I would prefer the SQL way anyway.
Dieter
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2026 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.
midrange.com
