Escape characters when using SELCT_SQL
Posted: 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
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