Ergebnis der Suchanfrage

• Forum: Datenbanken

  AW: Firebird Trigger verhindert Datenupdate

   
    by mkinzler, 11. Feb 2015
  Versuch mal:
  
  CREATE TRIGGER TEST_BU0 FOR TEST
  ACTIVE BEFORE UPDATE POSITION 0
  AS
  begin
  if (new.pe_deltag = 't') then begin new.pe_deldate = current_timestamp; end
  if (new.pe_deltag = 'f') then begin new.pe_deldate = null; end
  end
  ^