Subject Re: [IBO] TIBOQuery generating invalid SQL "under the hood"
Author Bjørge Sæther
""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...

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

???

--
Bj�rge S�ther
bjorge@hahaha_itte.no