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/3...er-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")
Bookmarks