I'll give you a real example that could justify this need: In my ERP, I store some global configuration data in a config table. In several triggers, I need to keep reading this config table to get some values and use in IF's, etc. For batch operations, triggers will be executed several times. A much better/efficient approach would be to store some of the config data in session context variables, so there would be no need to keep reading the config table every time.
When any user changes some sensitive config data, I would like that all the attachments to "refresh" its session context variables, to reflect the new values. PS: I could do something similar at the client side, using the currently Firebird events, but unfortunately, they cannot be trusted. []s Carlos http://www.firebirdnews.org FireBase - http://www.FireBase.com.br AdSF> On 26/02/2015 10:29, Carlos H. Cantu wrote: >> >> Those special triggers would be associated to an EVENT, not to a >> TABLE. When the associated event is fired in any of the active >> attachments, all the active attachments "interested" in that event >> would run the trigger. >> >> AdSF> But this intrigues me. Why would you want more than one attachment to AdSF> respond to an event? AdSF> Won't they will cause a race condition? AdSF> Adriano AdSF> ------------------------------------------------------------------------------ AdSF> Dive into the World of Parallel Programming The Go Parallel Website, sponsored AdSF> by Intel and developed in partnership with Slashdot Media, is your hub for all AdSF> things parallel software development, from weekly thought leadership blogs to AdSF> news, videos, case studies, tutorials and more. Take a look and join the AdSF> conversation now. http://goparallel.sourceforge.net/ AdSF> Firebird-Devel mailing list, web interface at AdSF> https://lists.sourceforge.net/lists/listinfo/firebird-devel ------------------------------------------------------------------------------ Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
