|
In my experience, no... that looks more like a human construct.
Probably started out with more in the 'where' clause, had issues, paired it down... added a few brackets to segment it... but never cleaned it up.
|
|
|
|
|
oh well, it gave me a good WTF moment and a laugh...
|
|
|
|
|
|
Yes.
The queries generated by the QBE-editor are sometimes a source of great wonder (and confusion).
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Yes and No actually ...
... AFAIK Access versions prior to 2007 did do the crazy brackets thing.
But 2007 onwards did not.
I have a client (government department) stuck on Access 2003. Another client has Access 2007.
I noticed the difference in the brackets thing between those two versions.
Unless there is some setting somewhere I don't know about (I'm not an Access dev y'know).
|
|
|
|
|
would you admit to being an access dev?
|
|
|
|
|
I have admitted this in the past, but then I always say that it's not the tool that is used that's the problem, it is the tool that uses it.
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
Sure - at my age, I'm immune to peer pressure 
I have been doing small contracts for various units of a State Government for about 5 years.
I charge them more than I do my regular clients. Nearly everyone employed full-time at this Dept is a lawyer or para-legal of some sort. They are cool with very high hourly rates.
And I definitely tell them "I am an Access developer". I would say I spend about 4 weeks a year being (posing as?) an Access Dev.
Officially, any custom-software they want must be built by the State Govt IT Dept (average delivery schedule: 5 - 10 years).
But they can get stuff done in Access, because according to MS, it's not "dev" software.
Often I work on Access DB's that were originally built by "actual" Access Dev's. I have seen their web-sites, and chatted by phone with one of them. So they are not "posers" like me.
The design and code of those DB's are ... interesting.
My work is easier in those cases, because I am constantly telling the users: "I can make this stuff a LOT easier for you". "No, you don't need to keep doing that, we can get Access to do it for you".
What happened, after the first job I did for a unit of this Dept, is that my users boasted about "their" Access guy around the water cooler, I got called in by another unit, etc.
Not a full time living there, but good pin-money.
I learned to program in BASIC on a Tandy TRS-80 in the late 70's while I was working as a Diesel mechanic in an iron-ore mine.
In the more than 30 years since then I have been paid to code in COBOL, RPG, Visual Basic, VB.Net, C#. And the SQL - don't forget the SQL. In all of those languages and environments SQL is the most useful tool you can have. Even in Access.
Back to the original question: When that stupid Query Builder tool in Access gives me the tom-tits, I just switch over to SQL View - suddenly everything is sweetness and light!
(once I've deleted all the brackets of course)
|
|
|
|
|
Are you sure you can exclude ((SQL Management) Studio) as the (source of (those brackets ()))))? I think the query designer there sometimes produces them too.
|
|
|
|
|
The guilty party said that he just copied/pasted the query from access. Trying to keep em away from things like the query designer though, I'm even getting em to make views with TSQL and not that bloody view designer...
|
|
|
|
|
I have been using MS SQL Server since it first came out (in the mid-nineties).
For the first few years we were using a set of Sybase manuals because we didn't have any SQL Server manuals (and Google was very unresponsive back then).
In those days, if you knew what the differences were between Sybase and SQL Server you were at Guru level.
But I have never used the "View Designer". The couple times I stumbled into it by accident, I got out of there ASAP.
To be honest, it's not that I disdain it's UI, SQL skills, or anything like that.
I just don't understand it. I have seen people who can go in there, make views, copy the SQL out to use elsewhere etc. I can't do that.
I have been coding SQL since the early 80's (DEC VAX RDB). I can code SQL queries faster than I can say what I am doing. But I don't get that View Designer.
|
|
|
|
|
LOL... feel that one, I started in Dataease and DB4...
|
|
|
|
|
I've seen the Access wizards generate SQL that looks like that.
David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting
|
|
|
|
|
Gaaahhh!!!
I recently registered on a website that doesn't accept upper-case letters in a username/email-address. 
So today I tried to log in -- all it does is tell me that the login failed. Over and over and over again. 
Can't you at least do a freakin' ToLower on whatever the user entered?
|
|
|
|
|
|
den2k88 wrote: sent an e-mail with the registered password in clear-text (with all the implications on their storage method),
Unicode-encrypted? 
|
|
|
|
|
den2k88 wrote: * the "forgot passowrd" button sent an e-mail with the registered password in clear-text (with all the implications on their storage method),
So.. do they have fraud insurance to cover themselves when their system gets hacked?
|
|
|
|
|
I sincerely hope so. Better than that I hope someone hacks them and pays my insurance bill but that's not gonna happen. 
GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver
|
|
|
|
|
Name them and shame them.
"If you don't fail at least 90 percent of the time, you're not aiming high enough."
Alan Kay.
|
|
|
|
|
Well, if Lloyd was a Genius he would have an insurance company with a misspelled Alliance.
Gosh this is almost CCC material.
GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver
When I was six, there were no ones and zeroes - only zeroes. And not all of them worked. -- Ravi Bhavnani
|
|
|
|
|
StringComparison.IgnoreOrdinalCase
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
digimanus wrote: StringComparison.OrdinalIgnoreCase
FTFY.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Thank you
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
If they don't accept UpperCase in username/email, that's weird but still not too bad. Imagine they do accept it, AND insist on case-sensitivity when you log-in... "Bernie" != "bernie" - which one did I use?
E.g. with postgresql, string comparison is case-sensitive by default...
|
|
|
|
|
PIEBALDconsult wrote: upper-case letters in a username/email-address.
There's your first problem. 
But yes, a simple problem to fix.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
