Subject Re: [firebird-support] Cannot order By
Author Helen Borrie
At 06:40 PM 8/07/2003 +0700, you wrote:
>Hello Every one,
>I have created a view with code below :
> "RIN",
> "IN",
> "OUT",
> "DATE",
> "UOM",
> "PRICE",
> "NOTE",
>) 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.


order by "DATE"