03/04/2021 06:19:15 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_cxc_c_aero_carga
METODO: ConsultaTarifaAplicadaDocFact
ERROR->:
Invalid query: ERROR: invalid input syntax for integer: ""
LINE 9: WHERE f.id_fact = '';
^
Whole query:
SELECT f.itinerario,
f.itinerario AS aero_ruta,
0 AS id_aero_ruta,
car.*
FROM cxc_aero_doc_carga car
INNER JOIN cxc_factura f ON f.id_fact = car.id_doc_carga
AND car.tipdoc_carga='FACT'
WHERE f.id_fact = '';