|
| WL.Replace in query not working ? |
| Iniciado por vvido, 31,jul. 2018 14:26 - 3 respuestas |
| |
| | | |
|
| |
Miembro registrado
94 mensajes |
|
| Publicado el 31,julio 2018 - 14:26 |
I am trying to change the value of a string in the query before returning the result, but no luck.
If I create a formula in the query like this
WL.Replace (MYTABLE.Comments, "A", "B")
the designer complains because of incorrect syntax |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
2.682 mensajes |
|
| Publicado el 31,julio 2018 - 15:21 |
Hi,
Try this
REPLACE(MYTABLE.Comments, 'A', 'B')
--
Cordialement,
Philippe SAINT-BERTIN |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
94 mensajes |
|
| Publicado el 31,julio 2018 - 16:01 |
Thanks, it works this way.
I have expected double quotes since I am calling WLanguage procedure. |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
1.640 mensajes |
|
| Publicado el 01,agosto 2018 - 10:44 |
Philippe SB a écrit :
Hi,
Try this
REPLACE(MYTABLE.Comments, 'A', 'B')
--
Cordialement,
Philippe SAINT-BERTIN
Nice.. That's typically the kind of "error" where I can spend 2 hours before I find the solution ! |
| |
| |
| | | |
|
| | | | |
| | |
|