iOS Question SQL insert

Discussion in 'iOS Questions' started by moore_it, Feb 16, 2015.

  1. moore_it

    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
     
  2. Erel

    Erel Administrator Staff Member Licensed User

    Always use ExecuteNonQuery2.
    Code:
    SQL.ExecuteNonQuery2("INSERT INTO tablename VALUES (?)"Array("caffe'"))
     
  3. moore_it

    moore_it Active Member Licensed User

    Try it,
    thanks Erel !
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice