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.

Throwback Thursday: July 11, 2024

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.
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.
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.
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!
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.
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.

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

Cover image generated by Ideogram

All original code samples by Mike Wolfe are licensed under CC BY 4.0