Thank you all for your feedback.

It has restored my sanity. I was going crazy trying to figure out why this wasn't working. I should have read the documentation. Now, what documentation should I have read??

Jim

--- In firebird-support@yahoogroups.com, Norman Dunbar <Norman@...> wrote:
>
> Morning Jim,
>
> > ...
> > How can I create the view so that the ORDER BY clause is variable?
>
> Create the view without the order by, and select from it and specify an
> order by as desired?
>
> Create view myview .....;
> ...
>
> Select <stuff> from myview
> order by <desired_column>;
>
> Oracle, FYI, doesn't allow views to be created with a variable order by
> either.
>
> Cheers,
> Norman.
>
>
> --
> Norman Dunbar
> Dunbar IT Consultants Ltd
>
> Registered address:
> Thorpe House
> 61 Richardshaw Lane
> Pudsey
> West Yorkshire
> United Kingdom
> LS28 7EL
>
> Company Number: 05132767
>