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/
>
>
>