try order by 6
or fully quality the "DATE"
as
order by A.TglTerima

> -----Original Message-----
> From: Yosi [mailto:ysundawa@...]
> Sent: Tuesday, 8 July 2003 10:06 PM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Cannot order By
>
>
> That doesn't work either,
> Is it because I use the "Outer Join" Syntax ?
> Is there any other way to make my DATA ordered without that syntax (order
> by) ?
>
>
> ----- Original Message -----
> From: "Helen Borrie" <helebor@...>
> To: <firebird-support@yahoogroups.com>
> Sent: Tuesday, July 08, 2003 6:45 PM
> Subject: Re: [firebird-support] Cannot order By
>
>
> > At 06:40 PM 8/07/2003 +0700, you wrote:
> > >Hello Every one,
> > >
> > >I have created a view with code below :
> > >
> > >CREATE VIEW "QSALDORAW" (
> > > "RIN",
> > > "IN",
> > > "OUT",
> > > "BALANCE",
> > > "DATE",
> > > "UOM",
> > > "PRICE",
> > > "NOTE",
> > > "WAREHOUSECODE",
> > > "WAREHOUSENAME",
> > > "ITEMNAME"
> > >) AS
> > >
> > >select A.Rin, A.Qty, B.Pakai as Pakai, (A.Qty - B.Pakai) as Saldo,
> > >A.TglTerima, A.UOM, A.Price, A.Ket, A.KodeGdg,
> > >A.namaGdg, A.NamaBrg
> > >from qRawIn A left outer join qAkumPakaiRaw B
> > >on A.Ket = B.Ket and A.Rin = B.RIn and A.KEt = B.ket and A.tglTerima =
> > >B.tglMasuk and
> > >A.KodeGdg = B.KodeGdg
> > >
> > >
> > >the problem is, I cannot call the view if I added the ORDER BY Syntax.
> > >Ie : Select * from qsaldoraw order by DATE
> > >
> > >Th Error appear like :
> > >Arithmetic exception, numeric overflow, or string truncation
> > >Statement: select * from qsaldoraw order by DATE
> > >
> > >This error never come out if i don't use the ORDER BY syntax.
> > >But I need to do a FIFO trancation which need to look at the date data.
> >
> >
> > Try
> >
> > order by "DATE"
> >
> > heLen
> >
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > firebird-support-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>