Subject | Parser messes up SQL containing FIRST |
---|---|
Author | aleksander_oven |
Post date | 2003-10-13T22:40:26Z |
Hi,
I'm using IBO 4.2Ie with Firebird 1.5 RC6 and D7 and I'm having
trouble executing this simple SQL:
SELECT FIRST 1 * FROM Table WHERE (ID = 1)
The preparation process of IBOQuery seems to damage the SQL so that
this gets sent to the server:
SELECT FIRST 1 *
, Table.RDB$DB_KEY
FROM Table WHERE (ID = 1)
Needles to say, this statement fails miserably. Any help is
appreciated...
Kind regards,
Aleksander Oven
I'm using IBO 4.2Ie with Firebird 1.5 RC6 and D7 and I'm having
trouble executing this simple SQL:
SELECT FIRST 1 * FROM Table WHERE (ID = 1)
The preparation process of IBOQuery seems to damage the SQL so that
this gets sent to the server:
SELECT FIRST 1 *
, Table.RDB$DB_KEY
FROM Table WHERE (ID = 1)
Needles to say, this statement fails miserably. Any help is
appreciated...
Kind regards,
Aleksander Oven