Lines Matching defs:pSql

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