have a grid where the SQL command is based on an inner join
It has always worked.
Today it gave me incorrect selections. I cut and pasted the SQL statement into the systems SQL Database Builder and it worked, so I knew it was correct.
I created a new app with same join, copied the newly generated SWL statement back into my app, and it worked
Somehow the SQL in the app got corrupted. Anyone else have this issue? Its worrisome.