SQLite, prepare/step/finalize

rc =sqlite3_prepare( Db, qry_getnewid, -1, &stmt, NULL);
if( SQLITE_OK !=rc)
  diediedie( "...");

rc =sqlite3_step( stmt);
if( SQLITE_ROW !=rc)
  {
    sqlite3_finalize( stmt);
    diediedie( "...");
  }

...

a->id =sqlite3_column_int( stmt, 0);

...

sqlite3_finalize( stmt);

SQLite, open db and exec sql

rc =sqlite3_open(DB_FILENAME, &Db);
if( rc)
  diediedie( "...");

rc =sqlite3_exec( Db, tbldef_accounts, NULL, 0, &zErrMsg);
if( SQLITE_OK !=rc)
  diediedie( zErrMsg);

...

sqlite3_close( Db);