Subject Re: Error in distinct in prepared statements
Author Roman Rokytskyy
Hi,

> I use JBird 1.0.1 with Yaffil, and I obtained following error while
> try to prepare SELECT statement with DISTINCT --
...
> I try to prepare such statements in isql, and it succeeded, so it
> looks like bug in JBird.

How are you able to prepare statement in isql? I do not think this is
JayBird problem, because we do not parse statement at all, just send
it over the wire and read server's response back. This error message
was generated by server, not by JayBird. Are you sure that the server
to which you have connected to supports isc_dsql_prepare operation for
this statement (maybe you used dialect 1?)?

Thanks!
Roman