Subject | Re: [IBO] TIBOQuery generating invalid SQL "under the hood" |
---|---|
Author | Helen Borrie |
Post date | 2003-02-13T01:28:40Z |
At 02:19 AM 13/02/2003 +0100, you wrote:
Helen
>""Bjørge Sæther"" <bjorge@...> skrev i meldingWhat kind of error?
>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...
>Why does this not work with IBO, while e.g. BDE handles it ?Not enough info here to guess.
Helen