Friday, May 2, 2014
Tip of the Day: Using UPDATE Triggers with Oterro 9.5
Product.: Oterro 9.5 (32/64) www.oterro.com
Build...: 9.5.4.30430 or higher www.rupdates.com
Keywords: Triggers, Stored Procedures
Section.: Oterro 9.5, Designing Web Applications
R:BASE Trigger is procedural code that is automatically executed in
response to certain events on a particular table in the database.
Triggers can restrict access to specific data, perform logging, or
audit data modifications.
There are "BEFORE" triggers and "AFTER" triggers which identifies
the time of execution of the trigger. A trigger can be set to
automatically run a Stored Procedure BEFORE and/or AFTER an UPDATE,
DELETE, or INSERT event occurs in a table.
There are three triggering events that cause triggers to fire:
. INSERT event (as a new record is being inserted into the database)
. UPDATE event (as a record is being changed)
. DELETE event (as a record is being deleted)
You may define specific Triggers using the Triggers section of the
Data Designer:
Database Explorer | Tables | Design Table | Table Designer | Triggers
. Before Insert
. After Insert
. Before Update
. After Update
. Before Delete
. After Delete
When designing web applications for your R:BASE 9.5 database, using
various web development tools, a direct connection to R:BASE database
is established via System DSN using Oterro 9.5. www.oterro.com
Did you know that the latest update of Oterro 9.5 (Build: 9.5.4.30430)
now supports UPDATE Triggers?
Yes, now you can use your favorite web development tool that will
properly execute all Triggers, if defined, including the UPDATE
trigger.
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
31 years of continuous innovation!
16 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
