Subject Re: [firebird-support] Cannot order By
Author Lester Caine
> Oh yes, Sorry I forgot,
> I translate a little of my to english,
> the original version is
> Select * from qSaldoRaw order By TglMasuk

I would be more careful on upper and lower case. I only use
upper case for names. You have tgl* and Tgl* in the metadata
you sent in the next message, and if IBConsole is adding
""'s then it becomes important.

You need TglMasuk in the fields of the view and not just in
the join.
Since TglMasuk is not one of the fields in the view
QSaldoRaw you can't ORDER ON it.

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

Lester Caine
L.S.Caine Electronic Services