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

QUALITY_SetUser

 

��������

(��� �������� ��� �������� QUALITY_SetUser)

 

�����������

CREATE TRIGGER "QUALITY_SetUser" FOR QUALITY
ACTIVE BEFORE INSERT OR UPDATE POSITION 0
as
begin
--  if (new.createtime is null) then
    new.createtime = current_timestamp;
--  if (new.userid is null) then
  execute procedure Users_GetID(null) RETURNING_VALUES new.userid;
end

 

     Previous topic Chapter index Next topic