At 10:29 AM 13/02/2003 +1100, you wrote:

>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

Either
select users.*, users.rdb$db_key from users
or
select *, rdb$db_key from users

(sorry, v. busy)

H.

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