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!
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Rodolfo Duarte