| Subject | AW: [firebird-support] Update database to new version? |
|---|---|
| Author | Steffen Heil |
| Post date | 2004-07-26T22:05:46Z |
Hi
First, try "ORDER BY B.TITLE ASC" and "ORDER BY A.NAME ASC", I think only
the second will fail.
If so, try "ORDER BY B.TITLE ASC, AUTHOR ASC", since you renamed that field.
Otherwise, try "ORDER BY 3 ASC, 16 ASC", as you can specify fields by their
field index.
Regards,
Steffen
First, try "ORDER BY B.TITLE ASC" and "ORDER BY A.NAME ASC", I think only
the second will fail.
If so, try "ORDER BY B.TITLE ASC, AUTHOR ASC", since you renamed that field.
Otherwise, try "ORDER BY 3 ASC, 16 ASC", as you can specify fields by their
field index.
Regards,
Steffen