pcsoft.us.windevCopyright 2026, PC SOFT1 Aug 2018 10:44:16 Z31 Jul 2018 14:26:57 ZI 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 [code:wl] WL.Replace (MYTABLE.Comments, "A", "B") [/code] the designer complains because of incorrect syntax30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66422-replace-query-not-working/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)François C.pcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66422-replace-query-not-working-66436/read.awp1 Aug 2018 10:44:16 ZPhilippe SB a écrit : > Hi, > > Try this > REPLACE(MYTABLE.Comments, 'A', 'B') > > > -- > Cordialement, > > Phili…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66422-replace-query-not-working-66436/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66422-replace-query-not-working-66436/read.awpWL.Replace in query not working ?vvidopcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66422-replace-query-not-working-66427/read.awp31 Jul 2018 16:01:14 ZThanks, it works this way. I have expected double quotes since I am calling WLanguage procedure.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66422-replace-query-not-working-66427/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66422-replace-query-not-working-66427/read.awpWL.Replace in query not working ?Philippe SBpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66422-replace-query-not-working-66426/read.awp31 Jul 2018 15:21:08 ZHi, Try this [code:sql] REPLACE(MYTABLE.Comments, 'A', 'B') [/code] -- Cordialement, Philippe SAINT-BERTINhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66422-replace-query-not-working-66426/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66422-replace-query-not-working-66426/read.awpWL.Replace in query not working ?