This topic is locked
[SOLVED]

Erro on Select SQL Error State:HY000, Native Error Code: CCCCCCCC, ODBC Error: [Devart][ODBC][Fireb

4/6/2022 2:00:21 AM
PHPRunner General questions
O
onlline author

Hi,

I recive the error on the run this seletc,

Error executing query:
SQL Error State:HY000, Native Error Code: CCCCCCCC, ODBC Error: [Devart][ODBC][Firebird]Malformed string

MY SELECT

/ RELATORIO FUNCIONANDO /

SELECT
SUM(VALOR) AS valor,
DATA,
ESPECIE,

CASE
WHEN (TIPO = 'SANGRIA') THEN 'SANGRIA'
WHEN (TIPO= 'SUPRIMENTO') THEN 'SUPRIMENTO'
WHEN (TIPO NOT like '%SANGRIA%' AND TIPO NOT LIKE '%SUPRIMENTO%') then especie
end AS NOVA

FROM MOV_OPERADORES
WHERE (VALOR > 0) AND (DATA ='now')
GROUP BY DATA, ESPECIE, NOVA

/ RELATORIO FUNCIONANDO /

Thanks in advanced.

Sergey Kornilov admin 4/7/2022

Where do you get this error, in PHPRunner itself or in the generated application?

What happens when you run it manually against your database?

O
onlline author 4/8/2022

Thanks,

I reinstall the driver ODBC.