There is or was a prefix to indicate raw SQL. Something like
'::SQL:: to be used in the WhereClause to indicate 'raw' sql.
I wondow if that might help

------------------------------------------------------------
---

----- Original Message -----
From: "aleksander_oven" <aleksander_oven@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, October 13, 2003 4:40 PM
Subject: [IBO] Parser messes up SQL containing FIRST


| 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
|
|
|
|
___________________________________________________________________________
| IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
| without the need for BDE, ODBC or any other layer.
|
___________________________________________________________________________
| http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
| keyword-searchable FAQ, community code contributions and more !
|
| Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|
|
|