CREATE OR ALTER trigger bar_ad_log for bar
active after delete position 0
as
declare variable V_MSG varchar(255);
declare variable V_USER integer;
begin
if (gen_id(rep_mode,0)=0 and user<>'SMPOST') then begin
if (not (old.ARTICUL starting with 'FICTIVE')) then begin
V_MSG = 'Удален штрихкод '||old.barcode;
if (exists(select * from CONFIG where PARAMNAME='TruncLogCARDSCLA' and BOOLPARAM='T')) then begin

as
declare variable V_MSG varchar(255);
declare variable V_USER integer;
begin
if (gen_id(rep_mode,0)=0 and user<>'SMPOST') then begin
if (not (old.ARTICUL starting with 'FICTIVE')) then begin
V_MSG = ' Удален РЎв‚¬РЎвЂљРЎР‚Р С‘РЎвЂ¦Р С”Р С•Р Т ‘ '||old.barcode;

CREATE TRIGGER BAR_AI_LOG FOR BAR
ACTIVE AFTER INSERT POSITION 0
as
declare variable V_MSG varchar(255);
declare variable V_USER integer;
begin
if (gen_id(rep_mode,0)=0 and user<>'SMPOST') then begin
if (not (new.ARTICUL starting with 'FICTIVE')) then begin
V_MSG = 'Добавлен штрихкод '||new.barcode;
if (exists(select * from CONFIG where PARAMNAME='TruncLogCARDSCLA' and BOOLPARAM='T')) then begin
...

as
declare variable V_MSG varchar(255);
declare variable V_USER integer;
begin
if (gen_id(rep_mode,0)=0 and user<>'SMPOST') then begin
if (not (old.ARTICUL starting with 'FICTIVE')) then begin
V_MSG = 'Удален штрихкод '||old.barcode;
if (exists(select * from CONFIG where PARAMNAME='TruncLogCARDSCLA' and BOOLPARAM='T')) then begin
select id from cur_user into :v_user;
delete from LOG
where OBJECT='CARDSCLA' and ACT='UPDATE' and
KEYS=old.ARTICUL and MANAGER=:V_USER and