At 09:46 PM 12/02/2003 +0100, you wrote:

>Hello,
>
>I'm having this problem with TIBOQuery modifying SQL under the hood,
>resulting in invalid SQL:
>
>was:
>SELECT
> *
>FROM
> INVOICE
>
>...is modified to:
>
>SELECT
> *
>, INVOICE.RDB$DB_KEY
>FROM
> INVOICE
>
>...which won't compile.
>
>I surely see what's the problem: Table 'INVOICE' does not exist.
>But - what's reported is some invalid char ',' - naturally when you see what
>SQL is being generated.
>
>This must be a bug. Agreed ?

No. The ' is not an invalid char. Because your table has no primary key
and you have set KeyLinksAutoDefine to true, IBO is appending the
RDB$DB_KEY to your select * specification list in order to get a unique
row identifier. The comma is required to extend the list.

When you say it "won't compile", what do you mean exactly?

regards,
Helen

>--
>Bjørge Sæther
>bjorge@hahaha_itte.no
>
>
>
>
>___________________________________________________________________________
>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/