Subject | Re: [IBO] TIBOQuery generating invalid SQL "under the hood" |
---|---|
Author | Bjørge Sæther |
Post date | 2003-02-13T01:19:22Z |
""Bj�rge S�ther"" <bjorge@...> skrev i melding
news:b2du97$8o2$1@......
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
news:b2du97$8o2$1@......
> Hello,what
>
> 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
> SQL is being generated.Now, even more problems:
>
> This must be a bug. Agreed ?
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