| Subject | Re: [firebird-support] ORDER BY got message 'token unknown' |
|---|---|
| Author | Alexandre Benson Smith |
| Post date | 2004-04-07T15:20:54Z |
At 13:12 07/04/2004 +0000, you wrote:
You cannot use order by in views.
You should create your view without the order by clause and when you select
from that view put the order by.
like this:
Select * from MyView order by MyColumn
see you !
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
----------
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.654 / Virus Database: 419 - Release Date: 06/04/2004
[Non-text portions of this message have been removed]
>i hav a simple view that implements an ORDER BY, but i canĀ“t compileHi !
>it into the DB because of an error like 'ORDER BY token unknown'.
>Anyone knows what is happening???
>
>sorry about my english!!! :)
You cannot use order by in views.
You should create your view without the order by clause and when you select
from that view put the order by.
like this:
Select * from MyView order by MyColumn
see you !
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
----------
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.654 / Virus Database: 419 - Release Date: 06/04/2004
[Non-text portions of this message have been removed]