On Sat, Jul 27, 2013 at 2:04 AM, Stephan Beal <sgb...@googlemail.com> wrote: > Hi, all, > > i'm porting some code from one sqlite3-using project (Fossil SCM) to > another sqlite3-using project (a prototype for Fossil v2) and i came across > this code snippet: > > while( rc==SQLITE_OK && z[0] ){ > pStmt = 0; // <==== type=(sqlite3_stmt*) > rc = sqlite3_prepare_v2(g.db, z, -1, &pStmt, &zEnd); > if( rc!=SQLITE_OK ) break; > if( pStmt ){ > ... > } > z = zEnd; > } > > My question is: is the if(pStmt) block there a case of too much error > handling, or can it really happen that prepare() returns OK but also leaves > pStmt as NULL (e.g. for an empty SQL statement)???
pStmt will be NULL if zSql contains only a comment or whitespace. There is a comment about this in sqlite3_exec (legacy.c). _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users