Skip to Content
0
Former Member
May 09, 2008 at 06:36 AM

Error with create trigger command

46 Views

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