Lines Matching refs:execsql
25 set v [catch {execsql {DELETE FROM test1}} msg]
32 set v [catch {execsql {DELETE FROM sqlite_master}} msg]
39 execsql {CREATE TABLE table1(f1 int, f2 int)}
40 execsql {INSERT INTO table1 VALUES(1,2)}
41 execsql {INSERT INTO table1 VALUES(2,4)}
42 execsql {INSERT INTO table1 VALUES(3,8)}
43 execsql {INSERT INTO table1 VALUES(4,16)}
44 execsql {SELECT * FROM table1 ORDER BY f1}
47 execsql {DELETE FROM table1 WHERE f1=3}
50 execsql {SELECT * FROM table1 ORDER BY f1}
53 execsql {CREATE INDEX index1 ON table1(f1)}
54 execsql {PRAGMA count_changes=on}
55 execsql {DELETE FROM 'table1' WHERE f1=3}
58 execsql {SELECT * FROM table1 ORDER BY f1}
61 execsql {DELETE FROM table1 WHERE f1=2}
64 execsql {SELECT * FROM table1 ORDER BY f1}
72 execsql {CREATE TABLE table2(f1 int, f2 int)}
73 set v [catch {execsql {DELETE FROM table2 WHERE f3=5}} msg]
78 set v [catch {execsql {DELETE FROM table2 WHERE xyzzy(f1+4)}} msg]
86 execsql {DELETE FROM table1}
89 execsql {SELECT count(*) FROM table1}
92 execsql {BEGIN TRANSACTION}
94 execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
96 execsql {COMMIT}
97 execsql {SELECT count(*) FROM table1}
100 execsql {DELETE FROM table1}
103 execsql {BEGIN TRANSACTION}
105 execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
107 execsql {COMMIT}
108 execsql {SELECT count(*) FROM table1}
111 execsql {PRAGMA count_changes=off}
112 execsql {DELETE FROM table1}
115 execsql {SELECT count(*) FROM table1}
118 execsql {BEGIN TRANSACTION}
120 execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
122 execsql {COMMIT}
123 execsql {SELECT count(*) FROM table1}
127 execsql "DELETE FROM table1 WHERE f1==$i"
129 execsql {SELECT count(*) FROM table1}
132 execsql "DELETE FROM table1 WHERE f1>50"
133 execsql {SELECT count(*) FROM table1}
137 execsql "DELETE FROM table1 WHERE f1==$i"
139 execsql {SELECT f1 FROM table1 ORDER BY f1}
143 execsql "DELETE FROM table1 WHERE f1==$i"
145 execsql {SELECT f1 FROM table1 ORDER BY f1}
148 execsql "DELETE FROM table1 WHERE f1!=48"
149 execsql {SELECT f1 FROM table1 ORDER BY f1}
163 execsql {DELETE FROM table1}
164 execsql {COPY table1 FROM 'data1.txt'}
165 execsql {DELETE FROM table2}
166 execsql {COPY table2 FROM 'data1.txt'}
168 execsql {SELECT count(*) FROM table1}
171 execsql {SELECT count(*) FROM table2}
174 execsql {SELECT f1 FROM table1 WHERE f1<10 ORDER BY f1}
177 execsql {SELECT f1 FROM table2 WHERE f1<10 ORDER BY f1}
180 execsql {DELETE FROM table1 WHERE f1>7}
181 execsql {SELECT f1 FROM table1 ORDER BY f1}
184 execsql {DELETE FROM table2 WHERE f1>7}
185 execsql {SELECT f1 FROM table2 ORDER BY f1}
188 execsql {DELETE FROM table1}
189 execsql {SELECT f1 FROM table1}
192 execsql {INSERT INTO table1 VALUES(2,3)}
193 execsql {SELECT f1 FROM table1}
196 execsql {DELETE FROM table2}
197 execsql {SELECT f1 FROM table2}
200 execsql {INSERT INTO table2 VALUES(2,3)}
201 execsql {SELECT f1 FROM table2}
206 execsql {
215 execsql {
226 execsql {
231 execsql {
237 execsql {
242 execsql {
258 execsql {
274 execsql {SELECT * FROM t3}
282 execsql {SELECT * FROM t3}
290 execsql {SELECT * FROM t3}