Hi,
Kiel W. wrote:
Could someone point out what I missing or not understanding on this? I'm
trying to do a simple text bind to search for people with the last name
"Fullman". However my return code (rc) from sqlite3_step() is the same as
SQLITE_DONE. I'm assuming this means it doesn't find anything.
Also, how do I pull the character string of the sqlite statement to be
executed from 'sqlite3_stmt' ?
Thanks for the hand.
-- code snipet --
sqlite3_open( "test.db", &database );
size = sprintf( buf, "CREATE TABLE People( fname varchar(25), fname
varchar(25) );" );
I think it stops right here, because you've got fname twice. That
induces an error.
Also, I'd execute each statement by itself.
HTH
Ulrik Petersen
--
Ulrik Petersen, PhD student, MA, B.Sc.
University of Aalborg, Denmark