"localhost:/firebird/data/ILICHEVSK2.FDB". �������� Previous topic Chapter index Next topic

SILAGEPACKSQUALITY_ID

 

��������

(��� �������� ��� �������� SILAGEPACKSQUALITY_ID)

 

�����������

CREATE TRIGGER SILAGEPACKSQUALITY_ID FOR SILAGEPACKSQUALITY
ACTIVE BEFORE INSERT POSITION 0
as
begin
  if (new.SILAGEPACKSQUALITYID is null) then begin
    new.SILAGEPACKSQUALITYID = gen_id(SILAGEPACKSQUALITYGEN,1);
    new.QUALITYDATE = current_date;
  end
end

 

     Previous topic Chapter index Next topic