Subject | RE: [IBO] "order by coalesce" problem |
---|---|
Author | Jason Wharton |
Post date | 2004-12-13T21:44:24Z |
> 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.
Regards,
Jason Wharton