Hi,

> i hav a simple view that implements an ORDER BY, but i can´t compile
> it into the DB because of an error like 'ORDER BY token unknown'.
> Anyone knows what is happening???

ORDER BY isn't supported in a VIEW.

You can do:

select ... from myview ORDER BY something

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com