*, fieldname
as a select list is invalid
you'll need to list the fields completely
Alan

-----Original Message-----
From: news@... [mailto:news@...]On Behalf Of
Bjørge Sæther
Sent: Thursday, 13 February 2003 7:46 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] TIBOQuery generating invalid SQL "under the hood"


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 ?

--
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/