If your formula is as simple as you post, I would just eliminate the field "Total" from the table, and calculate it (as Total1 - Total2) when you need it.
>Hi folks!
>
>I have a little problem: Imagine one table with just four fields: PrimaryKey, Total1, Total2 and Total... This table had Insert, Update and Delete triggers.
>
>I just want to calculate Total (using triggers) but I'm receiving an error message: Cannot Update the Cursor.
>
>In my stored procedure I have the line:
>
>Replace Total With Total1 - Total2
>
>
>My program runs something like that:
>
>Begin Transaction
>Update MyTable Where PrimaryKey = "BlaBla" Set Total2 = 500
>End Transaction
>
>
>I do not use Table or Row Buffer.
>
>TIA!
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)
