Hello,
I'm using SapDb 7.4.3.31 under Win2000(SP4).
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.
Andrzej Kaźmierkiewicz
REMEDIUM
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
