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

ps 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
This topic is locked and no more replies can be posted.