Hello Everybody
I want to create some database triggers for logging deletes
CREATE TABLE "BWALLE"."STDELETELOG"
(
"UHRZEIT" Timestamp NOT NULL DEFAULT TIMESTAMP,
"BENUTZER" Char (40) ASCII NOT NULL DEFAULT USER,
"TABELLE" Char (30) ASCII NOT NULL DEFAULT ' ',
"TABELLENKEY" Char (30) ASCII NOT NULL DEFAULT ' ',
"KEYWERT" Char (30) ASCII NOT NULL DEFAULT ' '
)
This one is ok and works as expected !!!!
CREATE TRIGGER STPERSONALSTAMMDELETE FOR BWALLE.STPERSONALSTAMM AFTER DELETE EXECUTE (
INSERT INTO BWALLE.STDELETELOG (UHRZEIT,BENUTZER,TABELLE,TABELLENKEY,KEYWERT)
VALUES (DEFAULT, DEFAULT,'STPERSONALSTAMM','STPERSONALSTAMMID', :OLD.STPERSONALSTAMMID);
)
This returns and error ????
CREATE TRIGGER AUTONUMDELETE FOR BWALLE.AUTONUM AFTER
DELETE EXECUTE (
INSERT INTO BWALLE.STDELETELOG (UHRZEIT,BENUTZER,TABELLE,TABELLENKEY,KEYWERT)
VALUES (DEFAULT, DEFAULT,'AUTONUM',:OLD.SUCHBEGRIFF, CHR(:OLD.WERT));
)
General error;-7035 POS(161) DEFAULT specification not allowed for this column
The first default is marked red ???
Any help welcomed
Best regards
Albert