I am making my first foray into Universe triggers having knowledge only of how it works with Unidata and the Universe documentation, and am having a devil of a time. Is it a requirement that in Universe, the file must be created via SQL in order to put triggers on it? And then what of this CREATE TRIGGER syntax? The documentation says: CREATE TRIGGER trigger_name [BEFORE | AFTER] UPDATE ...but it doesn't nominate the file where the trigger is to be deployed. I found an example elsewhere that has a bit more syntax: CREATE.TRIGGER trigger_name [BEFORE | AFTER] UPDATE ON file_name FOR EACH ROW But entering that leaves me at a SQL+ prompt and when I <cr> it gives me a message that says "You must create a schema before you may create SQL tables.". My trigger subroutine is compiled and catalogued according to the documentation, and I'd really like to test it, but ... these issues keep getting in the way. Anybody care to launch a rescue? -Kevin HYPERLINK "mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED] http://www.PrecisOnline.com
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.4 - Release Date: 4/6/2005 ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
