Be sure to make that one parameter "*some.subroutine". The subroutine
needs to be UV globally cataloged, even if you are running in a Pick
flavor account.
--
Regards,
Clif
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER & ASSOCIATES
Tel: +1 619 460 5678 Web: www.oliver.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
On Nov 26, 2007, at 10:50 PM, [EMAIL PROTECTED] wrote:
Try this:
CREATE TRIGGER filename.trigger BEFORE INSERT OR UPDATE OR DELETE ON
filename FOR EACH ROW CALLING "some.subroutine";
Note the semi-colon at the end (;). It is very important.
Regards,
Raul.
"Keith Johnson
(DSLWN)"
<[EMAIL PROTECTED] To
o.nz> <[email protected]>
Sent
by: cc
[EMAIL PROTECTED]
stserver.u2ug.org
Subject
[U2] [UV] Can I get some
advice on
triggers?
11/27/07 12:20 AM
Please respond to
[EMAIL PROTECTED]
er.u2ug.org
Hi,
I'm hoping someone can give me some help on triggers. I want to put a
trigger on a file to datestamp address changes.
The system manual (25119270.pdf) says that triggers aer set up by the
command
CREATE TRIGGER trigger.name [BEFORE|AFTER|UPDATE]
But when I try that I get an SQL prompt. We don't use SQL at all - is
there some way of setting up triggers without it? Is there another
manual I should look at?
Thanks, Keith.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
