Subject Re: [Firebird-Java] PreparedStatement and nested queries
Author Marco Parmeggiani
In data Fri, 2 Apr 2004 12:01:10 +0200, hai scritto:

> A question on PreparedStatement parameter index (the one used in setString
> etc), let's suppose to have this query with some nested queries:

argh. more info.
i'm using the latest 1.0 driver.
i'm testing the code against a 1.0 server and against a 1.5 server.
the problem seems to be in the server.
1.5 server prepare the statement with parameters in order of appearance in
the query string.
para4
para6
para7

1.0 server prepare the statement with parameters in order of "statement"
para7
para4
para6

i am a bit upset about this... switching to 1.5 will broke my code. did i
do something wrong doing those type of queries?

ciao