SQL error when using 'IN' or 'NOT IN' in where condition of read data function

psalvescom526 17 May, 2023
Hi, all.

I'm encountering a problem with Chronoconnectivity v 6.012
Whenever I create a "Read Data" function that has a where condition that uses 'IN' or 'NOT IN' I always get an SQL error. Something like:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''11' LIMIT 50' at line 1

I have checked that the function works fine otherwise. If I change the where condition to use = instead of IS there is no error.

Has anyone encountered this and has been able to solve it?

Thanks
You need to login to be able to post a reply.