pcsoft.us.windevCopyright 2026, PC SOFT7 Aug 2017 11:03:00 Z4 Aug 2017 13:40:00 ZUPDATE Test sSQ1L IS string sSQL2 IS string sSQ1L = EDT_NoName1 //Replace string sSQL2 = EDT_NoName2 // Find string SET mame= sSQL1 WHERE Test.mame = sSQL2 How can i link the edit fields or a local variable to the query?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62138/read.awp7 Aug 2017 11:03:00 ZChoose Parameter and when writing your query you will be automatically asked for the Parameter and there you can Input for examp…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62138/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62138/read.awpHow to find and replace in SQL codeguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62101/read.awp5 Aug 2017 12:48:00 ZQuote What if x>y SELECT CUSTOMER.CustomerName AS CustomerName, CUSTOMER.Company AS Company, CUSTOMER.ZipCode AS Zi…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62101/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62101/read.awpHow to find and replace in SQL codeguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62100/read.awp5 Aug 2017 11:31:00 Zcan you give a example on how i can do this? in training wd queries i found this ; ofc this only goes so far since they are in…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62100/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62100/read.awpHow to find and replace in SQL codeguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62099/read.awp5 Aug 2017 10:08:00 ZThe variables are in your program - send it to the query as parametershttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62099/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62099/read.awpHow to find and replace in SQL codeguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62095/read.awp4 Aug 2017 18:54:00 Ztheres only value and parameter in the options not variable;https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62095/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62095/read.awpHow to find and replace in SQL codeguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62094/read.awp4 Aug 2017 18:06:00 Zhi whoever you are, use query Generator choose update query select your file you get a list of items: click in the conditi…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62094/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62094/read.awpHow to find and replace in SQL codeguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62091/read.awp4 Aug 2017 16:49:00 Zno result with that code either; No replace took place and when trying to run the query directly i receive a initialisation er…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62091/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62091/read.awpHow to find and replace in SQL codeguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62090/read.awp4 Aug 2017 16:02:00 ZHi, make it : UPDATE Test sSQ1L IS string sSQL2 IS string sSQ1L = %1 //Replace string sSQL2 = %2 // Find string SET …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62090/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62086-how-find-and-replace-sql-code-62090/read.awpHow to find and replace in SQL code