Re: Calculating fields

[Dave Niezabitowski]

Phillip Ward Wrote:
-------------------------------------------------------
> Two possibilities:
> 1) Calculate the points as the data is stored in
> the table - for that you'll need a trigger that
> fires on an insert, do the calculation in that
> trigger and store the result. This is a good
> option of the formula never changes.
> 2) Calculate the points as the data is retrieved -
> for that you'll want a view that includes a
> calculated column that derives the points based on
> other values in the row.
>
> Which option you go for is entirely up to you (and
> whether you can translate Excel-ese into MySQL's
> DML syntax!).
>
> Regards, Phill W.


Phil,

Sorry, didn't see that you posted this. The forum here is in a format that I'm not used to.

Anyway, a trigger is what I'm thinking too. Reson being that I need to perform the calculation on INSERT and on UPDATE.

I posted the formula with field names in place where the spreadsheet cells were. Hopefully that will help.