Executing a query like:
SELECT count(*) FROM sometable
locks up the GUI and when it returns the Query stop
button is still enabled and no results appear.
However if one does:
SELECT count(*) AS somealias FROM sometable
the results appear with a column headed 'somealias'
So it seems like the results formatting might be
having trouble with aggregate functions not having
column names?
Logged In: YES
user_id=32217
Checking source...do you have a workaround yet?
dedmike
Logged In: NO
I did a count(*) using oracle as back end it worked for me
Logged In: NO
Works fine with MySQL too...probably need more detail on
what the database is, driver, etc, where it fails.