Delphi-PRAXiS - Einzelnen Beitrag anzeigen

**mkinzler**

Versuch mal:

SQL-Code:

			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

^

mkinzler (Moderator) Registriert seit: 9. Dez 2005 Ort: Heilbronn 39.851 Beiträge Delphi 11 Alexandria	#2 AW: Firebird Trigger verhindert Datenupdate 11. Feb 2015, 08:55 Versuch mal: markieren SQL-Code: 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 ^ Markus Kinzler
	Zitat

Einzelnen Beitrag anzeigen

AW: Firebird Trigger verhindert Datenupdate