Escape characters when using SELCT_SQL

This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
Post Reply
Taku Izumi
Posts: 53
Joined: Thu Dec 15, 2016 2:03 pm

Escape characters when using SELCT_SQL

Post by Taku Izumi » Fri Dec 27, 2024 12:19 pm

When I use SELECT_SQL command, I escape the escape characters with the Replaceall function.
I'm not sure if this is the best way to do it, because I have to code a lot of patterns.

#SQL := #SQL.ReplaceAll("'" '"')
#SQL := #SQL.ReplaceAll('\' '\\')
#SQL := #SQL.ReplaceAll('/' '\/')
....

Does anyone know a better way?

Best regards,
Taku

Post Reply