| Subject | Re: order by column index |
|---|---|
| Author | glennlbrown |
| Post date | 2003-09-01T11:28:41Z |
Sorry
I typed in the word COLUMN incorrectly. It shouldn't have been in my
first post.
From what I can see Firebird doesn't seem to have a problem with the
column index being used in the order by clause. I am testing
IBOConsole and it might be specific to this. I am going to test
through my own C++ Builder project and see if I can run existing
queries.
It seems that I have been running Interbase all the time anyway and
need to replace the gds32.dll file to be truly running Firebird.
Glenn
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:
I typed in the word COLUMN incorrectly. It shouldn't have been in my
first post.
From what I can see Firebird doesn't seem to have a problem with the
column index being used in the order by clause. I am testing
IBOConsole and it might be specific to this. I am going to test
through my own C++ Builder project and see if I can run existing
queries.
It seems that I have been running Interbase all the time anyway and
need to replace the gds32.dll file to be truly running Firebird.
Glenn
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:
> Hi Glenn,with
>
> > Up until now we have been using Interbase 6.0 and are testing
> > Firebird 1.5.
> >
> > We have a grid component that was written in-house and uses
> > the "ORDER BY COLUMN INDEX" eg ORDER BY COLUMN 1. This fails
> > the 'invalid ORDER BY clause' error. Is there any way to orderby
> > column index in Firebird?
>
> The the word "COLUMN" -
>
> SELECT * FROM EMPLOYEE
> ORDER BY 1
>
>
> With regards,
>
> Martijn Tonies
> Database Workbench - the developer tool for InterBase & Firebird
> Upscene Productions
> http://www.upscene.com