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!