I’m trying to run a simple query, with a condition that checks if the Status Code is IN a list of values.
StatusCode is a VARCHAR(20)
The query looks like this:
There are records that meet the condition. If I run the exact same query from Heidi (the SQL database management tool that I use), the database returns them.
Wappler, however, returns nothing. This is my result:
conversely, if I put a NOT IN with the same list, I get all the records, even those that do not match the strings in the list.
What am I doing wrong?
Many thanks for your help,