Michael Ruck <michael.ruck-4ptYESVdgRZ0eaEml/[EMAIL PROTECTED]>
wrote:
I have the tables of the following style:
CREATE TABLE Objects (ObjectID TEXT PRIMARY KEY, Class TEXT)
And I'm executing the following statement in the sqlite3 shell:
SELECT * FROM Objects WHERE ObjectID =
'{08021C17-46DD-4d83-A6FE-DDF0F7EC0AAE}'
In the shell this query succeeds. However if I try to do the same
thing via
sqlite3_prepare, sqlite3_bind_text16 and sqlite3_step, then
sqlite3_step
always returns 101 (SQLITE_DONE.)
The query you show does not have any parameters - what are you using
sqlite3_bind_text16 for? You are probably using a different query in
your program - show it.
As a wild guess, does your query look anything like this:
SELECT * FROM Objects WHERE ObjectID = '?'
(with question mark in quotes)? Note that '?' is a string literal
consisting of one question mark character, not a parameter placeholder.
The correct parameterized query is
SELECT * FROM Objects WHERE ObjectID = ?
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
