Subject | SELECT COUNT(*) causes Invalid Column Reference |
---|---|
Author | Martijn Tonies |
Post date | 2006-12-11T10:34:36Z |
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
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