0

I want to add a String data to my table of SQLite database which contains "...O'Clock..." in it. At the time of execution I am getting an syntax error near "Clock" due to the ' in my query string. How to pass ' into that query string?

Thanks in advance.

Zali Acc
  • 79
  • 1
  • 5

1 Answers1

2

You need to pass two ' for a single insertion of ' into your table.

Which means your string should be "...O''Clock..."

This should work.

Tamal Samui
  • 660
  • 8
  • 13