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.
-
Taku Izumi
- Posts: 53
- Joined: Thu Dec 15, 2016 2:03 pm
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