Hi Hilmar,
It is just an example... The formula is a little bit complicated than it. ;-)
But Thanks for your replay... John already answer me that it is not possible.
[]s!
>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!
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Rodolfo Duarte