Lines Matching refs:id

36   execsql { CREATE VIRTUAL TABLE t1 USING rtree_i32(id, x1, x2) }
44       if {$id==3} { db eval { DELETE FROM t1 WHERE id>3 } }
51   db eval { SELECT * FROM t1 ORDER BY +id } { 
52     if {$id==3} { db eval { DELETE FROM t1 WHERE id>3 } }
65     if {$id == $n} { nested_select [expr $n+1] }
83     set stmt [sqlite3_prepare db "SELECT * FROM t1 WHERE id = $row" -1 tail]
108     SELECT * FROM t1 WHERE id = $i 
120   CREATE VIRTUAL TABLE t1 USING rtree_i32(id, x1, x2);
130   DELETE FROM t1 WHERE id=25
134   CREATE VIRTUAL TABLE t1 USING rtree_i32(id, x1, x2);
162   CREATE VIRTUAL TABLE t2 USING rtree_i32(id, x1, x2) 
178     execsql { DELETE FROM t2 WHERE id = $i }
194     CREATE VIRTUAL TABLE t1 USING rtree(id,x1,x2,y1,y2);
199     db eval {SELECT id FROM t1} x {
200       db eval {DELETE FROM t1 WHERE id=$x(id)}