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?


Thanks in advance,

Christian