At 12:37 26/12/2002 +0200, you wrote:

>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.

The statement does not appear correct. What is the purpose of this sub-clause:

WHERE....999999 = :ID

Neither of these values is in the data - both are constants.

heLen