Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
Trigger question |
Fri, Apr 17 2009 10:28 AM | Permanent Link |
"James Relyea" | If I start a transaction in a stored proc, add a new record that fires a
trigger will the trigger's actions be part of the transaction as well? If so, for ACID purposes everything should be rolled back or committed properly then, right? Nested transactions are not supported too, correct? Probably a newbie question but there is 1 other DB who's triggers are independent of transactions. Thanks jr |
Fri, Apr 17 2009 1:01 PM | Permanent Link |
Fernando Dias Team Elevate | James,
> If I start a transaction in a stored proc, add a new record that fires a > trigger will the trigger's actions be part of the transaction as well? Yes. A rollback will also undo the actions executed inside the trigger. > Nested transactions are not supported too, correct? Correct. -- Fernando Dias [Team Elevate] |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |