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


Reply via email to