|Subject||RE: [IBO] "order by coalesce" problem|
> If I put SQL sentence likeShow us more please, what does the SQL trace monitor show?
> "select * from table order by coalesce(field1, field2)"
> into TIBOQuery, I got error:
> Dynamic SQL Error SQL error code = -104 Token unknown - line 4, char
> 30 ASC
> I tryed same sentence in IBExpert, and works fine.
My guess is the SQL parsing I do is messing it up.
I'll add this to my case of bugs to work out.