Problem:
When using multiple quotes in an SQL Query, for example trim(MAATRN) = '', our version of WebSmart assumes that the '' should be a ' resulting in an invalid SQL statement, trim(MAATRN) = '
Information:
This is a side effect of our generating RPG. When you want to "escape" a quote in RPG you double it up.
Workaround:
Change the query to trim(MAATRN) = ''''
Solution:
This has been resolved in WebSmart 7.2, and the code is now generated correctly automatically.
