1. 

   moore_it Active Member Licensed User

   Hello everybody,
   
   how i do to insert a field in a sqlite db table when i found an " ' " char ?
   
   example ...
   
   INSERT INTO tablename VALUES ('caffe'')
   
   Thanks in advice
   Toni

    

   moore_it, Feb 16, 2015

   #1
2. 

   Erel Administrator Staff Member Licensed User

   Always use ExecuteNonQuery2.
   

   Code:

   SQL.ExecuteNonQuery2("INSERT INTO tablename VALUES (?)", Array("caffe'"))

    

   Erel, Feb 16, 2015

   #2
3. 

   moore_it Active Member Licensed User

   Try it,
   thanks Erel !

    

   moore_it, Feb 17, 2015

   #3

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in