Lines Matching refs:pSql
13868 sqlite3_stmt *pSql = 0; in sqlite3_expert_new() local
13869 rc = idxPrintfPrepareStmt(pNew->db, &pSql, pzErrmsg, in sqlite3_expert_new()
13873 while( rc==SQLITE_OK && SQLITE_ROW==sqlite3_step(pSql) ){ in sqlite3_expert_new()
13874 const char *zSql = (const char*)sqlite3_column_text(pSql, 0); in sqlite3_expert_new()
13877 idxFinalize(&rc, pSql); in sqlite3_expert_new()
21455 static void explain_data_prepare(ShellState *p, sqlite3_stmt *pSql){ in explain_data_prepare() argument
21470 assert( sqlite3_column_count(pSql)>=4 ); in explain_data_prepare()
21471 assert( 0==sqlite3_stricmp( sqlite3_column_name(pSql, 0), "addr" ) ); in explain_data_prepare()
21472 assert( 0==sqlite3_stricmp( sqlite3_column_name(pSql, 1), "opcode" ) ); in explain_data_prepare()
21473 assert( 0==sqlite3_stricmp( sqlite3_column_name(pSql, 2), "p1" ) ); in explain_data_prepare()
21474 assert( 0==sqlite3_stricmp( sqlite3_column_name(pSql, 3), "p2" ) ); in explain_data_prepare()
21476 for(iOp=0; SQLITE_ROW==sqlite3_step(pSql); iOp++){ in explain_data_prepare()
21478 int iAddr = sqlite3_column_int(pSql, 0); in explain_data_prepare()
21479 const char *zOp = (const char*)sqlite3_column_text(pSql, 1); in explain_data_prepare()
21480 int p1 = sqlite3_column_int(pSql, 2); in explain_data_prepare()
21481 int p2 = sqlite3_column_int(pSql, 3); in explain_data_prepare()
21511 sqlite3_reset(pSql); in explain_data_prepare()
24676 sqlite3_stmt *pSql = 0; /* Compiled version of SQL statement below */ in lintFkeyIndexes() local
24764 rc = sqlite3_prepare_v2(db, zSql, -1, &pSql, 0); in lintFkeyIndexes()
24767 sqlite3_bind_int(pSql, 1, bGroupByParent); in lintFkeyIndexes()
24773 while( SQLITE_ROW==sqlite3_step(pSql) ){ in lintFkeyIndexes()
24776 const char *zEQP = (const char*)sqlite3_column_text(pSql, 0); in lintFkeyIndexes()
24777 const char *zGlob = (const char*)sqlite3_column_text(pSql, 1); in lintFkeyIndexes()
24778 const char *zFrom = (const char*)sqlite3_column_text(pSql, 2); in lintFkeyIndexes()
24779 const char *zTarget = (const char*)sqlite3_column_text(pSql, 3); in lintFkeyIndexes()
24780 const char *zCI = (const char*)sqlite3_column_text(pSql, 4); in lintFkeyIndexes()
24781 const char *zParent = (const char*)sqlite3_column_text(pSql, 5); in lintFkeyIndexes()
24823 rc2 = sqlite3_finalize(pSql); in lintFkeyIndexes()
25292 sqlite3_stmt *pSql = 0; in arListCommand() local
25298 shellPreparePrintf(pAr->db, &rc, &pSql, zSql, azCols[pAr->bVerbose], in arListCommand()
25301 oputf("%s\n", sqlite3_sql(pSql)); in arListCommand()
25303 while( rc==SQLITE_OK && SQLITE_ROW==sqlite3_step(pSql) ){ in arListCommand()
25306 sqlite3_column_text(pSql, 0), sqlite3_column_int(pSql, 1), in arListCommand()
25307 sqlite3_column_text(pSql, 2),sqlite3_column_text(pSql, 3)); in arListCommand()
25309 oputf("%s\n", sqlite3_column_text(pSql, 0)); in arListCommand()
25313 shellFinalize(&rc, pSql); in arListCommand()
25375 sqlite3_stmt *pSql = 0; in arExtractCommand() local
25396 shellPreparePrintf(pAr->db, &rc, &pSql, zSql1, in arExtractCommand()
25401 j = sqlite3_bind_parameter_index(pSql, "$dir"); in arExtractCommand()
25402 sqlite3_bind_text(pSql, j, zDir, -1, SQLITE_STATIC); in arExtractCommand()
25410 j = sqlite3_bind_parameter_index(pSql, "$dirOnly"); in arExtractCommand()
25411 sqlite3_bind_int(pSql, j, i); in arExtractCommand()
25413 oputf("%s\n", sqlite3_sql(pSql)); in arExtractCommand()
25415 while( rc==SQLITE_OK && SQLITE_ROW==sqlite3_step(pSql) ){ in arExtractCommand()
25417 oputf("%s\n", sqlite3_column_text(pSql, 0)); in arExtractCommand()
25421 shellReset(&rc, pSql); in arExtractCommand()
25423 shellFinalize(&rc, pSql); in arExtractCommand()