Hi,

My sql statement is not wrong.
If I do it in a stored procedure, everything is working.
There isn't any problem.

But if I do it with a Query component I get the same error message.
I think that: Problem=Query component. (IBX)

If my sql statement wrong, I can't do it in a sored procedure.

I Don't want to do a stored procedure for this.
I must run it with a query component.

----- Original Message -----
From: "Vinicius Barreira" <vinibarr@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, December 26, 2002 1:19 PM
Subject: Re: [ib-support] IBX QUESTION



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]



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



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/