Re: numericOnly trigger

[Derrick Betts <list(at)blueaxis(dot)com>]

Sean Davis wrote:
> Derrick Betts wrote:
> > I was wondering if anyone has built a trigger or etc. that verifies the
> > validity of an entry that is being posted to the database. I would like
> > to do the following:
> >    1.    Iterate through the column types in the table being updated
> >    2.    If the column type is numeric or real, or etc.,
> >        a. remove all the strings from the New.value
> >        b. set the New.value to the newly stripped value
> >     3.    Update the table with the modified values.
> >
> > The part I was hoping not to have to reproduce, if anyone has it and is
> > willing to share it, is the logic for iterating through the column types
> > and cleaning the specific values for update.
>
> I might be wrong, but I do not think your trigger will not actually fire
> if you try to do an update with text data in a column with a numeric
> datatype.  The type checking happens BEFORE a trigger fires, so you will
> simply get an error.
>
> Sean
If the trigger is a BEFORE UPDATE trigger will that not work?