?

Log in

No account? Create an account
sigh - Geoffrey Spear [entries|archive|friends|userinfo]
Geoffrey Spear

[ website | my Flickr photos ]
[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

sigh [Nov. 10th, 2006|11:43 am]
Geoffrey Spear
[Tags|]
[mood |annoyedannoyed]

I swear MS Access is the worst piece of software ever written.

The stupid SQL view window won't accept perfectly good mysql syntax telling me I have a missing operator, so instead of doing "COUNT (DISTINCT field) FROM table", which takes less than a second to execute when you do it in mysql, you have to do "COUNT (*) FROM (SELECT DISTINCT field FROM table)", which, besides being really ugly, takes forever to execute.

Even worse, if you use the Design View when working with an Oracle database and look in the SQL view, it gives you SQL that uses JOIN statements that don't actually work in Oracle. How it executes these queries is beyond me, because it's using the same damn ODBC driver I am and claiming to use a syntax that it can't possibly be using. Is it too much to ask that software not actually lie to me about what it's doing?
linkReply

Comments:
[User Picture]From: jeremiahblatz
2006-11-10 06:42 pm (UTC)
Not that I disagree, but, does
select count(*) form table group by field
run any faster?
(Reply) (Thread)
[User Picture]From: wooble
2006-11-10 07:23 pm (UTC)
not by much, and it returns 69,266 rows with the value 1 instead of 1 row with the value 69,266.
(Reply) (Parent) (Thread)
[User Picture]From: jeremiahblatz
2006-11-10 09:25 pm (UTC)
Oh, duh. Sometimes I think I'm of sub-human intelligence. THen I realize that's just ill-informed hubris.
(Reply) (Parent) (Thread)