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/
