>I'm creating a inventory transaction log using a trigger. According to the help, you must use buffering to use oldval unless your table has validation rules, which mine doesn't. OLDVAL appears to work just fine though. Is that valid to do or will I have problems?
I use it all the time. As I mentioned in my article (UT Magazine) on triggers, I consider that the help file is simply confusing in this case.
In summary, buffering is usually recommended
for other reasons, but it isn't requried for triggers to work correctly.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)