Subject | RE: [IBO] SELECT COUNT(*) causes Invalid Column Reference |
---|---|
Author | Jason Wharton |
Post date | 2007-01-21T00:44:46Z |
> Hello Jason,I was able to finally figure this out and fix it.
>
> I'm trying the latest IBO if Database Workbench, and when running
> an interactive query (that is: request live and so on) I'm getting
> an error on a select count:
>
> This query:
> select
> count(*)
> from
> ASSETS
>
>
> is send to the server like this:
>
> select
> count(*)
> , ASSETS.RDB$DB_KEY
> from
> ASSETS
>
>
> Causing:
> Dynamic SQL Error SQL error code = -104 invalid column reference
Please verify this in Beta 15 release of IBO 4.7.
Thanks,
Jason