When I Try:
CREATE TRIGGER logfileupdete FOR logfile AFTER INSERT EXECUTE
(
IF NOT EXISTS TABLE iud THEN
CREATE TABLE iud
(
id Integer NOT NULL DEFAULT SERIAL (1),
tb_name Char (30) ASCII,
operation Char (30) ASCII,
row_id Integer,
PRIMARY KEY ("id")
);
INSERT INTO admin.iud (tbname, operation, row_id) VALUES ('logfile', 'append', :new.id);
)
SAP DB gives me next message:
Syntax error or access violation;-3008 POS(82) Invalid keyword or missing delimiter.
and there is highlighted "TABLE" in expresion "IF NOT EXIST TABLE uid THEN".
It is not posible to use this statement in the trigger, or what I do incorrect?
-- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail: [EMAIL PROTECTED] ICQ#:160507472
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
