Re: [sqlite] How to insert this string?

Thanks for that. A QuotedString function will be useful indeed and will add that. In this case my language is B4A, which is similar to the old VB6. Very good and much recommended. RBS On Fri, Jul 27, 2018 at 11:32 AM, R Smith wrote: > On 2018/07/27 11:15 AM, Bart Smissaert wrote: > >> xxx is

Re: [sqlite] How to insert this string?

On 2018/07/27 11:15 AM, Bart Smissaert wrote: xxx is an identifier. It has no meaning at all in SQL and needs to be replaced by the app. Ok, so your app needs to replace xxx with 'A', 'B', 'C' then? Well, that depends on what language your App is? For example, assuming the query 'SELECT *

Re: [sqlite] How to insert this string?

xxx is an identifier. It has no meaning at all in SQL and needs to be replaced by the app. I have given the SQL string before and after the replacement: select * from table1 where a in(xxx) then after the string replacement it should be this: select * from table1 where a in('A', 'B', 'C') The

Re: [sqlite] How to insert this string?

On 2018/07/27 10:38 AM, Bart Smissaert wrote: Have a table like this: create table sql_replace(string_old text, string_new text) The idea is to do automatic string replacements in SQL. Say we have this SQL: select * from table1 where a in(xxx) then after the string replacement it should be

[sqlite] How to insert this string?

Have a table like this: create table sql_replace(string_old text, string_new text) The idea is to do automatic string replacements in SQL. Say we have this SQL: select * from table1 where a in(xxx) then after the string replacement it should be this: select * from table1 where a in('A', 'B',

RE: [sqlite] How to insert a string using C interface that contains both single and double quotes

ubject: Re: [sqlite] How to insert a string using C interface that contains both single and double quotes Hello, Wednesday, May 25, 2005, 11:30:00 PM, you wrote: SN> single and double quotes. I am using the C APIs of sqlite3_prepare and SN> sqlite3_exec to insert data into the database.

[sqlite] How to insert a string using C interface that contains both single and double quotes

Hi, I have a tricky situation where I have strings in my data that have both single and double quotes. I am using the C APIs of sqlite3_prepare and sqlite3_exec to insert data into the database. How do I prepare the query string in such case where the string data have both single and double