Oh yes, Sorry I forgot,
I trnslate a little of my to english,
the original version is
Select * from qSaldoRaw order By TglMasuk

And it doesn't work too .. :)
How could this be ?

----- Original Message -----
From: "Lester Caine" <lester@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, July 08, 2003 6:58 PM
Subject: Re: [firebird-support] Cannot order By


> >>CREATE VIEW "QSALDORAW" (
> >> "RIN",
> >> "IN",
> >> "OUT",
> >> "BALANCE",
> >> "DATE",
> >> "UOM",
> >> "PRICE",
> >> "NOTE",
> >> "WAREHOUSECODE",
> >> "WAREHOUSENAME",
> >> "ITEMNAME"
> >>) AS
> > Try
> >
> > order by "DATE"
>
> I dropped the 'reserved words' when I had a chance, so DATE
> became ORD_DATE or whatever. Then I don't have to worry
> about the ""'s ;)
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services
>
>
>
> 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/
>
>
>
>