Subject | Incompatible column/host variable data type. |
---|---|
Author | Sergio |
Post date | 2011-02-03T17:57:13Z |
[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
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