Lines Matching refs:zSql

142   const char *zSql;        /* Text of the SQL statement */  member
503 Tcl_Free((char *)pStmt->zSql); in dbFreeStmt()
646 static void DbTraceHandler(void *cd, const char *zSql){ in DbTraceHandler() argument
652 Tcl_DStringAppendElement(&str, zSql); in DbTraceHandler()
678 char *zSql = (char *)xd; in DbTraceV2Handler() local
685 Tcl_NewStringObj(zSql, -1)); in DbTraceV2Handler()
741 static void DbProfileHandler(void *cd, const char *zSql, sqlite_uint64 tm){ in DbProfileHandler() argument
749 Tcl_DStringAppendElement(&str, zSql); in DbProfileHandler()
1288 const char *zSql, /* SQL to compile */ in dbPrepare() argument
1295 return sqlite3_prepare(pDb->db, zSql, -1, ppStmt, pzOut); in dbPrepare()
1303 return sqlite3_prepare_v3(pDb->db, zSql, -1, prepFlags, ppStmt, pzOut); in dbPrepare()
1327 const char *zSql = zIn; /* Pointer to first SQL statement in zIn */ in dbPrepareAndBind() local
1342 while( (c = zSql[0])==' ' || c=='\t' || c=='\r' || c=='\n' ){ zSql++; } in dbPrepareAndBind()
1343 nSql = strlen30(zSql); in dbPrepareAndBind()
1348 && memcmp(pPreStmt->zSql, zSql, n)==0 in dbPrepareAndBind()
1349 && (zSql[n]==0 || zSql[n-1]==';') in dbPrepareAndBind()
1352 *pzOut = &zSql[pPreStmt->nSql]; in dbPrepareAndBind()
1379 if( SQLITE_OK!=dbPrepare(pDb, zSql, &pStmt, pzOut) ){ in dbPrepareAndBind()
1403 pPreStmt->nSql = (int)(*pzOut - zSql); in dbPrepareAndBind()
1404 pPreStmt->zSql = sqlite3_sql(pStmt); in dbPrepareAndBind()
1407 if( pPreStmt->zSql==0 ){ in dbPrepareAndBind()
1409 memcpy(zCopy, zSql, pPreStmt->nSql); in dbPrepareAndBind()
1411 pPreStmt->zSql = zCopy; in dbPrepareAndBind()
1416 assert( strlen30(pPreStmt->zSql)==pPreStmt->nSql ); in dbPrepareAndBind()
1417 assert( 0==memcmp(pPreStmt->zSql, zSql, pPreStmt->nSql) ); in dbPrepareAndBind()
1554 const char *zSql; /* Remaining SQL to execute */ member
1601 p->zSql = Tcl_GetString(pSql); in dbEvalInit()
1677 while( p->zSql[0] || p->pPreStmt ){ in dbEvalStep()
1680 zPrevSql = (p->zSql==zPrevSql ? 0 : p->zSql); in dbEvalStep()
1681 rc = dbPrepareAndBind(p->pDb, p->zSql, &p->zSql, &p->pPreStmt); in dbEvalStep()
1716 p->zSql = zPrevSql; in dbEvalStep()
2460 char *zSql; /* An SQL statement */ in DbObjCmd() local
2506 zSql = sqlite3_mprintf("SELECT * FROM '%q'", zTable); in DbObjCmd()
2507 if( zSql==0 ){ in DbObjCmd()
2511 nByte = strlen30(zSql); in DbObjCmd()
2512 rc = sqlite3_prepare(pDb->db, zSql, -1, &pStmt, 0); in DbObjCmd()
2513 sqlite3_free(zSql); in DbObjCmd()
2524 zSql = malloc( nByte + 50 + nCol*2 ); in DbObjCmd()
2525 if( zSql==0 ) { in DbObjCmd()
2529 sqlite3_snprintf(nByte+50, zSql, "INSERT OR %q INTO '%q' VALUES(?", in DbObjCmd()
2531 j = strlen30(zSql); in DbObjCmd()
2533 zSql[j++] = ','; in DbObjCmd()
2534 zSql[j++] = '?'; in DbObjCmd()
2536 zSql[j++] = ')'; in DbObjCmd()
2537 zSql[j] = 0; in DbObjCmd()
2538 rc = sqlite3_prepare(pDb->db, zSql, -1, &pStmt, 0); in DbObjCmd()
2539 free(zSql); in DbObjCmd()