I am not sure but I think that you need to order by the ordinal value of
the field...

So it would be ORDER BY 1

Probably wrong but heck, I may be able to answer one question one day...

-----Original Message-----
From: glennlbrown [mailto:glenn@...]
Sent: 01 September 2003 11:55
To: firebird-support@yahoogroups.com
Subject: [firebird-support] order by column index


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 with
the 'invalid ORDER BY clause' error. Is there any way to order by
column index in Firebird?

TIA

Glenn Brown



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/