You have two ")" after 999999
Change
WHERE (ID = :ID) OR (999999 = :ID))

to


WHERE (ID = :ID) OR (999999 = :ID)



ibrahim bulut <ibrahim@...> 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.


ibrahim Bulut
Software Developer
Republic Of Turkey


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


Yahoo! Groups SponsorADVERTISEMENT

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


Vinicius Barreira
Check-In Informática
Automação de Hotéis
São Bernardo do Campo - SP


---------------------------------
Busca Yahoo!
O melhor lugar para encontrar tudo o que você procura na Internet

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