On Wed, Mar 12, 2008 at 9:37 AM, C S <[EMAIL PROTECTED]> wrote: > > myString = "insert into Images(imageID, imageData) > values(?, ?); > > > status = sqlite3_prepare_v2(db, myString.c_str(), -1, > &statement, NULL); > > void *blob = reinterpretcast<char *>(imageArray); > > > status = sqlite3_bind_blob(statement, 2, blob, 10 * > sizeof(unsigned short), SQLITE_STATIC); > > statusu = sqlite3_finalize(statement); > > return sqlite3_last_insert_row(db); > > **************************** > > however when i do: > > select * from Images; > > i get no results returned to me. i just get returned > to the prompt. is there anything that i missed? thanks > again!!! >
You're missing a bind for the first column (the imageID), and more importantly, a call to sqlite3_step() - you do need one, otherwise the insert never executes. :) -- Matthew L. Creech _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users