| Subject | Re: [firebird-support] order by column index |
|---|---|
| Author | Martijn Tonies |
| Post date | 2003-09-01T10:59:04Z |
Hi Glenn,
SELECT * FROM EMPLOYEE
ORDER BY 1
With regards,
Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com
> Up until now we have been using Interbase 6.0 and are testingThe the word "COLUMN" -
> 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 with
> the 'invalid ORDER BY clause' error. Is there any way to order by
> column index in Firebird?
SELECT * FROM EMPLOYEE
ORDER BY 1
With regards,
Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com