Subject Re: [IBO] TIBOQuery generating invalid SQL "under the hood"
Author Helen Borrie
At 02:19 AM 13/02/2003 +0100, you wrote:
>""Bjørge Sæther"" <bjorge@...> skrev i melding
>news:b2du97$8o2$1@......
> > 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 ?
>
>Now, even more problems:
>
>SELECT
> *
>FROM
> INVOICE
>ORDER BY 1
>
>...also generates an error...

What kind of error?


>Why does this not work with IBO, while e.g. BDE handles it ?

Not enough info here to guess.

Helen