[no subject]

[Arjan Hoornstra <ahoor@YAHOO.COM>]

Heather,

I don't know what DB you're using but usually a view
can not be created using an order by, but in selects
from the view you can...

--- Heather Missel <hmissel@ROCHESTER.RR.COM> wrote:
> Thanks for the input, but this is in a View that is
> used as a prompt table.
> The View (as far as I can tell) does not support the
> order by clause.
>
>
> ----- Original Message -----
> From: Ted Houghton <THoughto@UNITEDROAD.COM>
> To: <SQR-USERS@list.iex.net>
> Sent: Wednesday, May 31, 2000 4:55 AM
>
>
> > Heather,
> > Have you tried adding an
> > order by b.end_dt
> > line?
> >
> >
> > -----Original Message-----
> > From: Heather Missel
> [mailto:hmissel@ROCHESTER.RR.COM]
> > Sent: Tuesday, May 30, 2000 9:28 PM
> > To: SQR-USERS@list.iex.net
> > Subject:
> >
> >
> > I am having a problem building a list box that
> contains calendar end dates
> > in the correct order.
> >
> > I build the SQL view as:
> >
> > Select to_char(b.end_dt, 'MM/DD/YYYY')      !Need
> this format
> > from ps_deptid_tbl
> >
> > The returned values are in alpha order, and I need
> them in date order.
> >
> > I have also tried to_date(to_char(b.end_dt,
> 'MM/DD/YYYY))
> > from ps_deptid_tbl
> >
> > This returns a SQL error "not a valid month"
> >
> > Any help would be greatly appreciated
> >
> > Dennis
> >
> >
> >
> >
> >
> >
> > *************************** N O T I C E
> **************************************
> >
> > This message and any attachments is intended only
> for the individual or
> company to which it is addressed and may contain
> information which is
> privileged, confidential or prohibited from
> disclosure or unauthorized use.
> If the recipient of this transmission is not the
> intended recipient, or the
> employee or agent responsible for delivering such
> materials to the intended
> recipient, you are hereby notified that any use, any
> form of reproduction,
> dissemination, copying, disclosure, modification,
> distribution and/or
> publication of this e-mail message or its
> attachments other than by it's
> intended recipient is strictly prohibited by the
> sender. If you have
> received it in error, please notify us immediately
> and destroy the message
> and all copies in your possession.
> >
> > This message has been scanned for viruses by
> Norton Antivirus.
> >


__________________________________________________
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
http://photos.yahoo.com