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