Hello,
I'm using SapDb 7.4.3.32 under WinXp(SP1).
I have a table and on insert trigger for it.
Trigger only call some DbProcedure:
CREATE TABLE A ("TXT" Varchar (100) ASCII)
//
CREATE DBPROC TEST AS
VAR x Integer;
SET x=0;
//
CREATE TRIGGER A_INSERT FOR A AFTER INSERT EXECUTE
(
CALL ADMIN.TEST;
)When I try to insert row in to this table:
INSERT A SET TXT='Test1'
my insert statement is executed witout error but there is no new row in the table.
When I change the trigger:
DROP TRIGGER A_INSERT OF A
//
CREATE TRIGGER A_INSERT FOR A AFTER INSERT EXECUTE
(
CALL ADMIN.TEST;
SELECT NOW() FROM ADMIN.DUAL; /* some insert, update, delete, select statement */
)
and when I execute my insert again everything is OK.
Is it bug, or am I doing something wrong?
Thank for your help and support. Regards, Dusan
-- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424
-=x=- Skontrolované antivírovým programom NOD32
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
