Close bracket symbol caused error in SQL statement

Close bracket symbol caused error in SQL statement.

bug.JPG

bug2.JPG

Try with single quotes ’ )’

Don’t use the provided sc_concat() macro, use the db function instead and it’s working.

jsb

Hello,

As JSB hinted, use the db function instead of sc_concat().

Issue reported to our bugs team.

regards,
Bernhard Bernsmann

Hello,

the two solutions said on this topic, some of them solve your problem? One was to use only single quotes, and the other was to use the concat your database.
Thank you.