Does that mean that I can't use the ORDER BY clause at all?

I tried using the ORDER BY clause with an explicit column name, e.g. ORDER BY LastName

That ran without an explicit error, but the result is incomplete. It shows only a small fraction of the table.

--- In firebird-support@yahoogroups.com, Ann Harrison <aharrison@...> wrote:
>
> On Tue, Feb 22, 2011 at 1:49 PM, drjimwalsh1 <drjimwalsh1@...> wrote:
>
> >
> >
> > How can I create the view so that the ORDER BY clause is variable?
> >
> >
> Sorry, you can't. I don't know which database supports that, but it's not
> part of the
> SQL standard and it's not in Firebird.
>
>
> Good luck,
>
> Ann
>
>
> [Non-text portions of this message have been removed]
>