[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