I'll have a look.

It shouldn't be trying to add KeyLinks to an aggregate SELECT.

Jason

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Martijn Tonies
> Sent: Monday, December 11, 2006 3:35 AM
> To: ibobjects@yahoogroups.com
> Subject: [IBO] SELECT COUNT(*) causes Invalid Column Reference
>
>
> Hello Jason,
>
> 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
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL,
> NexusDB, Oracle &
> MS SQL Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
>