Hi guys,
I have a simple stored procedure to update data, like this :
SET TERM ^ ;
CREATE PROCEDURE REG
AS
BEGIN
UPDATE table a set a.field1 = '123';
exit;
END^
SET TERM ; ^
When I run that procedure on flamerobin with this command:
execute procedure Reg.
It runs ok, but without a
At 05:23 p.m. 29/04/2014, trsk...@yahoo.com wrote:
When I run that procedure on flamerobin with this command:
execute procedure Reg.
It runs ok, but without a commit command, the field1 on table won't get update.
I rarely use store procedure to do update / insert / delete, but is this a
On 28 Apr 2014 22:23:43 -0700, trsk...@yahoo.com wrote:
I have a simple stored procedure to update data, like this :
SET TERM ^ ;
CREATE PROCEDURE REG
AS
BEGIN
UPDATE table a set a.field1 = '123';
exit;
END^
SET TERM ; ^
There is no need for a EXIT statement in this
Yes, I needed it, thanks for your answer.
Regards,
Anto
Hi guys,
I have a simple stored procedure to update data, like this :
SET TERM ^ ;
CREATE PROCEDURE REG
AS
BEGIN
UPDATE table a set a.field1 = '123';
exit;
END^
SET TERM ; ^
When I run that procedure on flamerobin with this command:
execute procedure Reg.
It runs
Hi guys,
I have a simple stored procedure to update data, like this :
SET TERM ^ ;
CREATE PROCEDURE REG
AS
BEGIN
UPDATE table a set a.field1 = '123';
exit;
END^
SET TERM ; ^
When I run that procedure on flamerobin with this command:
execute procedure Reg.
It runs
Hi,
Thanks for your replied.
Tried to use execute STATEMENT 'COMMIT', raised and error
Explicit transaction control is not allowed