Assalom aleikum.

>I am using IBX.
>I get this error message.
>"Dynamic Sql Error"
>"Sql Error Code= -804"
>"Incorrect Values Within SQLDA structure"
>
>My sql is that:
>===========
>SELECT ID, NAME, INVOICE_DATE FROM INVOICE
>WHERE (ID = :ID) OR (999999 = :ID))
>ORDER BY ID, INVOICE_DATE
>
>
>

in (999999 = :ID) you compare constant with parameter

Please, try

SELECT ID, NAME, INVOICE_DATE FROM INVOICE
WHERE (ID = :ID) OR (999999 = ID))
ORDER BY ID, INVOICE_DATE

to compare constant with field value.

Kubanychbek Tajmamat uloo,
kubanych@...