Lines Matching refs:i
97 int i, j, idx; /* Loop counters */ in sqliteInsert() local
246 for(i=0; i<nColumn; i++){ in sqliteInsert()
247 if( sqliteExprResolveIds(pParse, &dummy, 0, pList->a[i].pExpr) ){ in sqliteInsert()
250 if( sqliteExprCheck(pParse, pList->a[i].pExpr, 0, 0) ){ in sqliteInsert()
282 for(i=0; i<pColumn->nId; i++){ in sqliteInsert()
283 pColumn->a[i].idx = -1; in sqliteInsert()
285 for(i=0; i<pColumn->nId; i++){ in sqliteInsert()
287 if( sqliteStrICmp(pColumn->a[i].zName, pTab->aCol[j].zName)==0 ){ in sqliteInsert()
288 pColumn->a[i].idx = j; in sqliteInsert()
290 keyColumn = i; in sqliteInsert()
296 if( sqliteIsRowid(pColumn->a[i].zName) ){ in sqliteInsert()
297 keyColumn = i; in sqliteInsert()
300 pTabList, 0, pColumn->a[i].zName); in sqliteInsert()
378 for(i=0; i<pTab->nCol; i++){ in sqliteInsert()
380 j = i; in sqliteInsert()
383 if( pColumn->a[j].idx==i ) break; in sqliteInsert()
387 sqliteVdbeOp3(v, OP_String, 0, 0, pTab->aCol[i].zDflt, P3_STATIC); in sqliteInsert()
443 for(i=0; i<pTab->nCol; i++){ in sqliteInsert()
444 if( i==pTab->iPKey ){ in sqliteInsert()
453 j = i; in sqliteInsert()
456 if( pColumn->a[j].idx==i ) break; in sqliteInsert()
460 sqliteVdbeOp3(v, OP_String, 0, 0, pTab->aCol[i].zDflt, P3_STATIC); in sqliteInsert()
464 sqliteVdbeAddOp(v, OP_Dup, i+nColumn-j, 1); in sqliteInsert()
630 int i; in sqliteGenerateConstraintChecks() local
650 for(i=0; i<nCol; i++){ in sqliteGenerateConstraintChecks()
651 if( i==pTab->iPKey ){ in sqliteGenerateConstraintChecks()
654 onError = pTab->aCol[i].notNull; in sqliteGenerateConstraintChecks()
663 if( onError==OE_Replace && pTab->aCol[i].zDflt==0 ){ in sqliteGenerateConstraintChecks()
666 sqliteVdbeAddOp(v, OP_Dup, nCol-1-i, 1); in sqliteGenerateConstraintChecks()
674 sqliteSetString(&zMsg, pTab->zName, ".", pTab->aCol[i].zName, in sqliteGenerateConstraintChecks()
685 sqliteVdbeOp3(v, OP_String, 0, 0, pTab->aCol[i].zDflt, P3_STATIC); in sqliteGenerateConstraintChecks()
686 sqliteVdbeAddOp(v, OP_Push, nCol-i, 0); in sqliteGenerateConstraintChecks()
767 for(i=0; i<pIdx->nColumn; i++){ in sqliteGenerateConstraintChecks()
768 int idx = pIdx->aiColumn[i]; in sqliteGenerateConstraintChecks()
770 sqliteVdbeAddOp(v, OP_Dup, i+extra+nCol+1, 1); in sqliteGenerateConstraintChecks()
772 sqliteVdbeAddOp(v, OP_Dup, i+extra+nCol-idx, 1); in sqliteGenerateConstraintChecks()
872 int i; in sqliteCompleteInsertion() local
881 for(i=nIdx-1; i>=0; i--){ in sqliteCompleteInsertion()
882 if( aIdxUsed && aIdxUsed[i]==0 ) continue; in sqliteCompleteInsertion()
883 sqliteVdbeAddOp(v, OP_IdxPut, base+i+1, 0); in sqliteCompleteInsertion()
908 int i; in sqliteOpenTableAndIndices() local
914 for(i=1, pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext, i++){ in sqliteOpenTableAndIndices()
916 sqliteVdbeOp3(v, OP_OpenWrite, i+base, pIdx->tnum, pIdx->zName, P3_STATIC); in sqliteOpenTableAndIndices()
918 return i; in sqliteOpenTableAndIndices()
