Check out the callback parameter to sqlite_exec (the third parameter). The quickstart gives an example of this:
http://www.sqlite.org/quickstart.html Alternatively, check out sqlite3_prepare, sqlite3_bind, and sqlite3_step, sqlite3_result*, and sqlite3_finalize. All of these functions are documented here: http://www.sqlite.org/capi3ref.html Pat -----Original Message----- From: Keiichi McGuire [mailto:[EMAIL PROTECTED] Sent: Friday, July 28, 2006 3:36 PM To: sqlite-users@sqlite.org Subject: [sqlite] outputting select in cpp file? This sounds like a very simple problem, but I cannot figure it out! Basically what I have is this settings table that has a boolean data type, and I want to check it via a cpp program. sqlite_exec(db,"select flag from setting",0,0,&errMsg); and I want to be able to return a 0, or a 1 according to what I put into the flag entry. Thanks! -Keiichi