Previously saved query that executes for reports is not saving/parsing.
I have a query table that I use in reports without a problem.
Without even making a change in Edit Design mode I will get a parsing error when executing or saving.
Based on the location of the parsing error, it seems the source of the error is a logical operator I had been using in an IF statement. I had been using "||" instead of "OR" because "OR" had been generating an error when I wrote the SQL Query a few months ago. I guess now "OR" works. But when I change my "||" operators to "OR" operators, I still get a parsing error but without any location reference.
I'm stumped. Is there a development-environment parser I can subject my SQL to that will give me more detail?