[firebase-br] Error al Crear Trigger

Fabian Kruszelnicki fabianmk em gmail.com
Qua Out 14 16:16:25 -03 2015


Hola Lista
Cuando quiero crear el trigger de mas abajo:

CREATE TRIGGER DETCOMPRA_AD0 FOR DETCOMPRA
ACTIVE AFTER INSERT OR DELETE POSITION 0
AS
    declare variable NROPREF DOMENT4;
    declare variable NROCOMPROB DOMID;
    declare variable CTE DOMALFA3;
    declare variable IDSUC DOMID;
begin
  if (deleting) then
  begin
    /* Anula Imputacion Pedido Proveedor */
    update DETAPEDIPR set IDDETCPA = null, NROREFER = null, PREFREFER =
null,
                        COMPROB = null, CANTRECIBI = 0
                        where IDDETCPA = OLD.iddetcpa;
  end

  if (inserting) then
  begin
    select CP.DESCR, CO.NROPREF, CO.NROCOMPROB, CO.IDSUC FROM COMPRA CO
        inner join COMPRCPA CP on CO.IDCTECPA = CP.IDCTECPA where CO.IDCPA
= new.IDCPA
        into :CTE, :NROPREF, :NROCOMPROB, :IDSUC;
    update DETAPEDIPR set IDDETCPA = new.IDDETCPA, COMPROB = :CTE,
PREFREFER = :NROPREF, NROREFER = :NROCOMPROB, CANTRECIBI = new.CANTIDAD +
new.CANTBONIF
        where IDDETPED in (SELECT DP.IDDETPED from DETAPEDIPR DP inner join
PEDIDOPROV PP on DP.IDPEDPROV = PP.IDPEDPROV
                            where PP.NROPREF = new.PREFPEDPRO and
PP.NROCOMPROB = new.NROPEDPRO and DP.IDSUC = :IDSUC and DP.IDARTI =
new.IDARTI);
  end
end


me da el siguiente error:
can't format message 13:196 -- message file C:\Windows\firebird.msg not
found.
Dynamic SQL Error.
SQL error code = -804.
Feature not supported on ODS version older than 11.1.

tengo 3 bases de datos mas que no dan ese error y son exactamente iguales

Alguien me puede dar una ayuda?
Gracias


-- 
Fabian M Kruszelnicki



Mais detalhes sobre a lista de discussão lista