I have a query:
FAC_TYPE IN ('SHARED LANE', 'PAVED SHOULDER', 'BICYCLE LANE', 'SEPARATED BICYCLE LANE', 'BICYCLE BOULEVARD') And (NAME = '' Or NAME IS NULL) And UPDATED = 'YES'
(sorry I can't figure out, using the Syntax Highlighter, how to change the bold or color of the part I want highlighted)
The important part is I not only have NULL values, but blank ones that are only found using the NAME = ''. The issue is if I cut and past my code into the SQL it works fine, however if I save this query for future use and re-load it, the '' is removed each time (NAME = ) and the query fails until I manually have to add the quotes back in.
Here's what it looks like when loading it back up:
FAC_TYPE IN ('SHARED LANE', 'PAVED SHOULDER', 'BICYCLE LANE', 'SEPARATED BICYCLE LANE', 'BICYCLE BOULEVARD') And (NAME = Or NAME IS NULL) And UPDATED = 'YES'
Where NAME = shows up with out the ''.
Anyway to fix this when saving queries or is this just a bug?