At 12:19 PM 8/05/2003 +0200, you wrote:

>Hi,
>
>I have got a problem with the following
>SQL statement:
>
>SELECT LAST_NAME,
> FIRST_NAME,
> USER_NAME
>FROM T_BENUTZER
>WHERE AKTIV='J' ORDER BY LAST_NAME
>
>This statement is works fine, as long as
>you do not execute it using IBO.
>
>IBO changes my statement in the following
>way:
>
>SELECT First _NAME T_BENUTZER.USER_NAME
>FROM T_BENUTZER
>WHERE AKTIV='J'
>ORDER BY LAST_NAME ASC
>
>Of course, this does not work ;-)
>The change of my statement happens in
>TIB_Statement.SysPrepareSQL, which is called
>by TIB_Statement.SysGetRawSQL.
>
>I am using IBO 4.2 Id.
>
>Could someone please tell me what is happening?
>Is this a parser bug?

Yes. It was introduced in the 4.2Id patch. Daniel Rail fixed the parser
code and it appears to check out fine. A replacement patch is due out shortly.

Helen