On Tuesday, February 28, 2012 12:35:58 pm Lummis, Patrick J wrote:
> Hi Bartek,
>
> Thanks for the quick response.
>
> Syntax error cleared up and loads fine but executing the stored
> procedure fails to update the row.
From the usage I guessing this function is not being used in a trigger. As such
the ROW variable exists outside the table. If you want to UPDATE the table you
are going to have to do a hybrid of what you have:
update workorder set wfstatus='failed' where id=workorderRecord.id
assuming there is an 'id' field of some sort.
>
> Regards,
>
> Patrick
--
Adrian Klaver
adrian.klaver@gmail.com
