Re: [sqlite] [EXTERNAL] How to insert this string?

2018-07-27 Thread Bart Smissaert
Yes, that works indeed. I made a silly mistake and that is that the replace took already place in the table insertion SQL! Idea is that users can make a shortcut in the SQL and not type out a long string every time. All sorted now. RBS On Fri, Jul 27, 2018 at 10:25 AM, Hick Gunter wrote: > Inse

Re: [sqlite] [EXTERNAL] How to insert this string?

2018-07-27 Thread Hick Gunter
Insert into sql_replace values ('xxx','''A'',''B'',''C'''); Note: All single quotes. To include a single quote in a single quoted string, it needs to be doubled. Not sure what you are trying to do here. Build SQL queries on the fly? -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sq