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
"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