Hi,
I try to create a temp table in a trigger:
CREATE TRIGGER TR_INSUPD_ATZ_WB FOR DBA.T_ATZ_WB
AFTER INSERT, UPDATE EXECUTE (
CREATE TABLE TEMP.ATZ_VIEW (
BEGINN DATE,
ENDE DATE,
BESETZTE_STD FIXED(5,2),
FREIE_STD FIXED(5,2),
MODELL CHAR(2));
)
But get the message:
Base table or view already exists;-6000 POS(104) Duplicate table name:ATZ_VIEWIn the archive I found this http://lists.mysql.com/maxdb/21377 and expected that i can use temp tables in a trigger ? Elke
