On Tue, 19 Nov 2002 15:22:53 -0500, Myron Finegold wrote: >Bill, >Where do you store the triggers?
Myron, You create the trigger source code in RBEdit, as a source code file. It has some special syntax for SELECT, with "WHERE CURRENT OF sys_old" or "WHERE CURRENT OF sys_new" You turn your source code file into a "procedure" first, with the PUT command (and, when you update it, the SET PROC command), which stores it in the database for you, in the sys_procedures table. Then you turn you procedure into a trigger with the ALTER TABLE command's trigger syntax. I wrote an introductory article about triggers a few years ago that you can see at: www.downallconsulting.com/storproc.html Bill ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
