Hello.
1) Is it possible to get the OLD value and the NEW value simultaneously into "update" triggers (like into natural triggers of any DBMS)?
And if no way to do this, how to make the right something like a "cascading update of a non-foreign-key field into a table according to an updated field into another table"?
2) Is it correct to open and use transactions into triggers or it is more correct to open transactions before invoking qx::dao::* functions?
Thanks in advance.