Subject Re: [ib-support] Trigger problem
Author Doug Chamberlin
At 10/6/2001 07:11 PM (Saturday), bossman@... wrote:
>Got a table with fields in it. What i'd like to do is to put a vaue
>into a field via a trigger (this is fine and can do it).
>what i want then to do is to do a commit retain so the value that was
>just placed to appear on the screen (another words refresh the view).

You cannot commit from within a stored procedure or trigger. Do this from
your application after the SQL which invoked the trigger finishes.

Use the EXECUTE PROCEDURE statement to run a stored procedure from within a