Do I understand you're still seeing a segfault? I assume you're not seeing your "Year retrieved..." statement?
You haven't showed us your table definition. Change your strcmp to strcasecmp and see if that fixes it for you. Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate ________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of StyveA [styve.at...@technicolor.com] Sent: Thursday, May 12, 2011 7:39 AM To: sqlite-users@sqlite.org Subject: EXT :Re: [sqlite] Blob newbie problem Igor Tandetnik wrote: > > Prepare doesn't touch the database in any way. It just parses the text of > the statement, and prepares execution plan. Step is where the real work is > done. > > You need to issue BEGIN statement if you want to start an explicit > transaction (and then COMMIT or END to commit it, or ROLLBACK to roll it > back). If you don't, then each individual statement executes in its own > implicit transaction, which automatically starts when you first call > sqlite3_step, and commits when you call sqlite3_reset or sqlite3_finalize > (or rolls back if the statement fails). > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Well thanks for this informations, that's better in my mind ! I tried with your tips, and I've seen that I was missing the call of my callback function, and now the segfault is in it.. after that it should be ok I suppose.. Here are the changes : http://old.nabble.com/file/p31602596/example.c example.c I've removed the END line, and added the BEGIN. I've changed my mistake about "int blob". -- styve -- View this message in context: http://old.nabble.com/Blob-newbie-problem-tp31602374p31602596.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
