Subject Incompatible column/host variable data type.
Author Sergio
[FB 2.1]

Hello!! When I run this query...

SELECT
ID,
NOMBRE,
DIRECCION,
TELEFONOS
FROM
CLIENTES_ASEGURADOS
WHERE
(ID <> :ID)
AND
(ID_EMPRESAS = :ID_EMPRESAS)
AND
(
((NOMBRE = :NOMBRE) AND (:NOMBRE <> '')) OR
((DIRECCION = :DIRECCION) AND (:DIRECCION <> '')) OR
((TELEFONOS = :TELEFONOS) AND (:TELEFONOS <> ''))
)

I get this error:

Incompatible column/host variable data type.
Dynamic SQL Error.
SQL error code = -303.
arithmetic exception, numeric overflow, or string truncation.

I've been googling, and I've found something related to a bug, but as a matter of fact I don't undestand quite much, and it doesn't seem the same problem anyway.

http://tracker.firebirdsql.org/browse/CORE-3164?page=com.atlassian.jira.plugin.system.issuetabpanels%3Achangehistory-tabpanel

Thanks in advance!!!!

sergio