Try
SELECT USERS.*, USERS.RDB$DB_KEY FROM USERS

----- Original Message -----
From: "Alan McDonald" <alan@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, February 12, 2003 4:29 PM
Subject: RE: [IBO] TIBOQuery generating invalid SQL "under the hood"


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