>The first statement associated with an open connection is pointed to by >the pStmt of that connection. Once you've found the first statement call
>sqlite3_next_stmt() >on it to find the next one. ><https://www.sqlite.org/c3ref/next_stmt.html> > >Unfortunately the database connection is documented as 'opaque'. I'm not >certain for the ideal way in C to get the first statement from it. It is documented: This interface returns a pointer to the next prepared statement after pStmt associated with the database connection pDb. If pStmt is NULL then this interface returns a pointer to the first prepared statement associated with the database connection pDb. If no prepared statement satisfies the conditions of this routine, it returns NULL. This is how the sqlite_stmt vtab finds the non-finalized statements associated with a connection. -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users