Throwback Thursday: July 11, 2024
For those new to databases (and seasoned pros), queries are a mind-bogglingly amazing and infuriatingly obstinate tool. These tips help tame the beast.
With over a million words scattered across more than 1,300 articles on this blog, you've probably missed a few things here.
That’s why each week in "Throwback Thursday," we’ll revisit some standout posts. Expect a blend of my personal favorites, insightful articles from other great minds, and a touch of coding humor to keep things light.
Highlights from NoLongerSet.com
SQL Gotcha: When an OUTER JOIN Accidentally Becomes an INNER JOIN
If you apply a WHERE filter directly to the OUTER JOIN side of a query you will effectively turn it into an INNER JOIN.
Mike Wolfe
3 Gotchas of the SQL BETWEEN Statement
The SQL BETWEEN statement produces very readable condition expressions. But developers of all skill levels can still get into trouble with it.
Mike Wolfe
How to Set a Breakpoint Inside of an Access Query
Did you ever want to set a breakpoint inside of an executing query? How about inside a form event property? This trick lets you do it.
Mike Wolfe
Fixing Circular References in Access Queries
Did you get the error message, “Circular reference caused by alias ‘MyField’ in query definition’s SELECT list”? Don’t worry; it’s an easy fix!
Mike Wolfe
Beware TempVars in Queries
Many Access users rave about using TempVars with queries. I decided to see what the hype was about. What I found shocked me.
Mike Wolfe
Safely Using TempVars in Queries
Calling TempVars directly from a query can cause issues. Instead, use this simple wrapper function to save yourself some potential headaches.
Mike Wolfe
Wisdom from Around the Web
From the great Allen Browne:
Microsoft Access tips: Why is my query read-only?
List of reasons why a Microsoft Access query will yield non-editable results.
Microsoft Access tips: Surviving subqueries
Techniques to avoid 8 common errors, frustrations, limitations, and bugs when using subqueries in Microsoft Access.
Microsoft Access tips: Optimizing queries
How to get JET (the database engine in Microsoft Access) to execute queries quickly
Developer Humor
"What one programmer can do in one month, two programmers can do in two months." - Fred Brooks
— Programming Wisdom (@CodeWisdom) August 16, 2023
Cover image generated by Ideogram
