pcsoft.us.windevCopyright 2026, PC SOFT14 Apr 2018 12:44:00 Z12 Apr 2018 23:29:00 ZHi All I am needing some advice constructing the contents of a variable to be passed to SQL in an insert statement where the contents of the variable contains an apostrophe. I have tried replacing "'"with "''" using: Replace(MyString,"","''") I am still getting a failed insert when using HExecuteSQLQuery. Any ideas on the best way to handle this? Cheers André30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65206-sql-insert-and-apostrophe/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65206-sql-insert-and-apostrophe-65220/read.awp14 Apr 2018 12:44:00 ZHi King Will test that. In the meantime I have removed the PK from the analysis and reverted to HAdd and WX is not trashin…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65206-sql-insert-and-apostrophe-65220/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65206-sql-insert-and-apostrophe-65220/read.awpSQL Insert And Apostropheguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65206-sql-insert-and-apostrophe-65217/read.awp14 Apr 2018 00:09:00 ZAndre Pls see below sample if it works out for you: sSingleQ is string = "''" s2SingleQ is string = "''" sDesc is string…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65206-sql-insert-and-apostrophe-65217/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65206-sql-insert-and-apostrophe-65217/read.awpSQL Insert And Apostropheguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65206-sql-insert-and-apostrophe-65209/read.awp13 Apr 2018 07:09:00 ZHi Fabrice I have tried the double quote and "\'" and of course neither work. The db does take it from any other tool - doubl…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65206-sql-insert-and-apostrophe-65209/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65206-sql-insert-and-apostrophe-65209/read.awpSQL Insert And Apostropheguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65206-sql-insert-and-apostrophe-65207/read.awp13 Apr 2018 00:52:00 ZHi André, AFAIK, the best way is to use hadd instead of an insert statement, but if you insist, and if I remember correctly y…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65206-sql-insert-and-apostrophe-65207/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65206-sql-insert-and-apostrophe-65207/read.awpSQL Insert And Apostrophe