| Subject | RE: [IBO] TIBOQuery generating invalid SQL "under the hood" |
|---|---|
| Author | Alan McDonald |
| Post date | 2003-02-12T23:29:14Z |
Helen,
If I try to execute
SELECT *, USERS.RDB$DB_KEY FROM USERS
on a table of mine, the statement is rejected at the * character
In fact I've never been able to execute this type of statement...
How is is this done?
Alan
-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Thursday, 13 February 2003 10:15 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] TIBOQuery generating invalid SQL "under the hood"
At 09:46 PM 12/02/2003 +0100, you wrote:
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
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/
If I try to execute
SELECT *, USERS.RDB$DB_KEY FROM USERS
on a table of mine, the statement is rejected at the * character
In fact I've never been able to execute this type of statement...
How is is this done?
Alan
-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Thursday, 13 February 2003 10:15 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] TIBOQuery generating invalid SQL "under the hood"
At 09:46 PM 12/02/2003 +0100, you wrote:
>Hello,what
>
>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
>SQL is being generated.No. The ' is not an invalid char. Because your table has no primary key
>
>This must be a bug. Agreed ?
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
>--papers,
>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
>keyword-searchable FAQ, community code contributions and more !___________________________________________________________________________
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
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/