| Subject | Re: [Firebird-Java] Re: Tomcat +Firebird 1.5.3 + Jaybird - Order by clause error |
|---|---|
| Author | Roman Rokytskyy |
| Post date | 2006-01-26T11:23:48Z |
Hi,
after SELECT keyword - either put it into SELECT or change the sorted
column. This is exactly what I mean by changed behavior - and there are
other such changes since IB 6.0.
Roman
> I've used both Firebird 1.5.3.4870 and Interbase 6.0.1.It is in the ORDER BY clause - you reference column that is not in the list
> The query works from IB Console on both servers.
> I suspect a problem with the preparedStatement and the ORDER BY clause.
after SELECT keyword - either put it into SELECT or change the sorted
column. This is exactly what I mean by changed behavior - and there are
other such changes since IB 6.0.
Roman