CREATE OR ALTER TRIGGER SKLIT_H_BI0 FOR SKLIT_H
ACTIVE BEFORE INSERT POSITION 0
AS
DECLARE cnt int;
begin
  if (new.cod_cl is not null and new.cod_ap is not null) then begin
    select cod_cl
    from spr_ap
    where cod_cl = new.cod_cl and cod_ap = new.cod_ap into :cnt;
    if (row_count > 0) then
        new.autoload = 1;
    else new.autoload = 0;
  end

  if (new.cod_cl is not null and new.cod_ap is null or new.cod_ap = 0 ) then begin
    select cod_cl
    from spr_ap
    where cod_cl = new.cod_cl into :cnt;
    if (row_count > 0) then
        new.autoload = 0;
    else new.autoload = 1;
  end

end

active before insert or update position 0

if (new.cod_cl is not null and NULLIF(new.cod_ap, 0) is null) then begin