Un pequeño detalle.
Código SQL
[-]
create or alter procedure TAM ( ENTRADA integer)asdeclare variable OC integer;declare variable C1 integer;declare variable C2 integer;declare variable C3 varchar(10);declare variable C4 varchar(10);beginOC = gen_id(NOC,1); FOR EXECUTE STATEMENT 'SELECT NCORR, ITEM FROM DETCOMPRAS where noc =:entrada' ON EXTERNAL DATA SOURCE 'localhost:C:\DOMMO_LOCAL.FDB' AS USER 'SYSDBA' PASSWORD 'masterkey' INTO :C1, :C2 DO INSERT INTO DETCOMPRAS (NOC, NCORR, ITEM) VALUES (:OC, :C1, :C2); FOR EXECUTE STATEMENT 'SELECT PROVEEDOR, AVAL FROM COMPRAS where noc =:entrada' ON EXTERNAL DATA SOURCE 'localhost:C:\DOMMO_LOCAL.FDB' AS USER 'SYSDBA' PASSWORD 'masterkey' INTO :C3, :C4 DO INSERT INTO COMPRAS (NOC, PROVEEDOR, AVAL) VALUES (:OC, :C3, :C4);end
Espero que tenga solución.
Saludos.