Keith SQL requires a ";" (semi-colon) character along with a 'carriage return' character to signify the end of the command input.
There is no other way of creating or managing SQL triggers. Triggers require care in their design, so as not to impair your system performance. Forgetting to setting and release locks is a big no-no and isn't tolerated by a trigger. UV comes with a lot of UV/SQL documents: you need to read/study them a bit beforehand (or simply ask questions on this forum), at least review the "SQL User Guide" familarise yourself with the basics. "SQL Reference Guide" as all the info on trigger setup. Regards, David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Keith Johnson (DSLWN) Sent: Tuesday, November 27, 2007 3:39 PM To: [email protected] Subject: [U2] [UV] Can I get some advice on triggers? 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/
