Loose apostrophes are killing my DB integration

Hey all, these apostrophes are running loose in my data and it's giving me errors when putting text into a SQLite database - is there a wrapper or some kind of way that I can install appstrophe-inclusive names / text into a SQLite database?

I'm using SQLite. I had my own wrapper for the functions I need so I could log any issues in the same place I log everything else. Extending that for prepared statements turned out to be simple enough - and necessary as I was starting to have the same issues as the OP.

@Jean-YvesPochez it's just a shame they don't use the same syntax for different databases.

especially between sqlite and cubesql. i want to use prepared statement but have to cater for both since my application can be single user or multi user with just a extra file which i named xxlogin.rsd

@Ivan T You should also include a Link to the What is ActiveRecord and ARGen

Sorry, I try not to pimp my products too much because I know it can be annoying. But since you asked:

ARGen the ActiveRecord generator. In freebie mode you're limited to generating two tables at a time. Licensed lets you generate all the tables and starter UI you want. Work with desktop and web projects. For iOS only SQLite databases and no UI.

The situation is worse than you can imagine, if you don't use Prepared Statements. Not only are there different SQL syntaxes, but the syntax varies inside the LIKE command too. I also use it to clean up JavaScript text!

As a result I created a method to clean up the best I could, catering to both general SQL commands and the LIKE command on each platform: