Order by not possible in view?

[Sims, John (CDC/CCHP/NCBDDD) (CTR)]

Hi Ruslan,

I would like to add my "vote" for this one.  I use ORDER BY in SQL
Server views all of the time.  Very useful!

I'm not sure if Valentina supports it, but GROUP BY and Aggregate
functions are very useful in views also :-)

-John

 

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Danny Lewkin
> Sent: Friday, July 20, 2007 7:22 AM
> To: Valentina Developers
> Subject: Re: Order by not possible in view?
> 
> Done! ;-)
> 
> 
> http://valentina-db.com/bt/view.php?id=2474
> 
> 
> 
> 
> 
> 
> Op 20-jul-07, om 12:46 heeft Ruslan Zasukhin het volgende geschreven:
> 
> > On 20/7/07 11:38 AM, "Ruslan Zasukhin" <sunshine at public.kherson.ua>
> > wrote:
> >
> >> ----------------------------
> >>> results in an error :
> >>>
> >>> 10:19:40: Error: line 1:73: expecting ')', found 'ORDER'
> >>> 10:19:40: Error: Kernel error: 0x71000
> >>> 10:19:40: Error: line 1:73: expecting ')', found 'ORDER'
> >>>
> >>> Is 'ORDER BY' not possible in a view statement??
> >>> Is it possible, when it's not possible now, to make it 
> possible in 
> >>> the future? ;-) Then I will be happy to put a feature 
> request into 
> >>> mantis...
> >>
> >> If I am not mistaken this is by SQL Standard.
> >
> > Please add request into Mantis
> >
> >
> > --
> > Best regards,
> >
> > Ruslan Zasukhin
> > VP Engineering and New Technology
> > Paradigma Software, Inc
> >
> > Valentina - Joining Worlds of Information 
> http://www.paradigmasoft.com
> >
> > [I feel the need: the need for speed]
> >
> >
> > _______________________________________________
> > Valentina mailing list
> > Valentina at lists.macserve.net
> > http://lists.macserve.net/mailman/listinfo/valentina
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 
>