Hi,

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

When I write this sql statement to a query component,
query component builds 2 parameters.
Parameter 1=ID,
Parameter 2=ID

Parameter name is the same, So I get this error message.
If I change manually parameter two's name, there isn't any difference.
I get the same error message.

How Can I Solve This Problem.


ibrahim Bulut
Software Developer
Republic Of Turkey


[Non-text portions of this message have been removed]