rmmarsh
asked on
SQLITE: What do I need after an INSERT statement?
I have an INSERT statement, followed by a SQLITE3_EXEC, followed by a SELECT statement and another SQLITE3_EXEC. I'm getting an SQLERROR 21 (SQLITE_MISUSE) on the EXEC for the SELECT statement.
Line 11 (http://monobin.com/__d215dc84d) is giving me the error...
Am I missing something between the two EXECs? like a COMMIT, or?
Line 11 (http://monobin.com/__d215dc84d) is giving me the error...
Am I missing something between the two EXECs? like a COMMIT, or?
ASKER
Sorry, that didn't fix anything... still getting the 21.
http://www.sqlite.org/c3ref/bind_blob.html
you need to bind some variable fields in prepared statement
select ... from ... where ?=... and ?= ,,,
etc
you need to bind some variable fields in prepared statement
select ... from ... where ?=... and ?= ,,,
etc
ASKER
That particular SELECT statement is like "SELECT * FROM database"... I want all of the rows returned, although there will be only one...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you for your time... I appreciate it...
L from CardData";
to
L from CardData;";