>Hi,
>How could I get oldval and curval of a particlar field in update trigger in non-buffering and buffering mode?
>
>Thank you
My experiments indicate that OldVal() and CurVal() work both with and without buffering (the help seems to indicate otherwise). In other words, trigger functions (for instance, to update another table, or for an audit trail) would work, whether you use buffering, or not.
Programming is identical for both cases.
My article on triggers (
http://www.levelextreme.com/Magazine/June2002/Page21.asp) has an example of changes in one table updating another table. The code is the same, whether you use buffering or not.
HTH, 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)
