barrymavin
2013-02-16, 22:04
There is a known isssue in the windows ODBC libraries that causes them to get confused when you specify ? in a string literal in a SQL command.
http://stackoverflow.com/questions/3348932/how-to-avoid-odbc-parameterization-for-the-question-mark-character-within-lite
To get around this, do this:
insert into mytable(name) values("hello" + chr(63) + "world")
instead of:
insert into mytable(name) values("hello?world")
http://stackoverflow.com/questions/3348932/how-to-avoid-odbc-parameterization-for-the-question-mark-character-within-lite
To get around this, do this:
insert into mytable(name) values("hello" + chr(63) + "world")
instead of:
insert into mytable(name) values("hello?world")