Skip to content

Personal tools


Above in this comment thread: Chapter 13. Triggers - Part 2


Posted by wonderbison at 2006-05-24 04:47 PM
There is a typo within this extract which is also contained in the book and will be rectified at the next reprint.
In the section Using COLUMNS_UPDATED() the following code should read (the correction is the line of code)

Now if bits 2 and 4 are switched on within a byte, in other words, they have a setting of true (00010100), then the value is 4 + 16, which equates to 20. Therefore, to test whether the third and fifth columns of our table have BOTH been altered, we would use the following syntax:



Posted by kstone at 2006-05-25 03:32 PM
Great catch... thanks for letting us know!
Transaction Management
Reduce downtime and increase repeat sales by improving end-user experience.
Free White Paper
Database Recovery
Feeling the increased demands on data protection and storage requirements?
Download Free Report!

Powered by Plone