Lines Matching refs:execsql
25 set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3)}} msg]
32 set v [catch {execsql {INSERT INTO sqlite_master VALUES(1,2,3,4)}} msg]
39 execsql {CREATE TABLE test1(one int, two int, three int)}
40 set v [catch {execsql {INSERT INTO test1 VALUES(1,2)}} msg]
44 set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3,4)}} msg]
48 set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1,2,3,4)}} msg]
52 set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1)}} msg]
59 set v [catch {execsql {INSERT INTO test1(one,four) VALUES(1,2)}} msg]
66 execsql {INSERT INTO test1 VALUES(1,2,3)}
67 execsql {SELECT * FROM test1}
70 execsql {INSERT INTO test1 VALUES(4,5,6)}
71 execsql {SELECT * FROM test1 ORDER BY one}
74 execsql {INSERT INTO test1 VALUES(7,8,9)}
75 execsql {SELECT * FROM test1 ORDER BY one}
79 execsql {DELETE FROM test1}
80 execsql {INSERT INTO test1(one,two) VALUES(1,2)}
81 execsql {SELECT * FROM test1 ORDER BY one}
84 execsql {INSERT INTO test1(two,three) VALUES(5,6)}
85 execsql {SELECT * FROM test1 ORDER BY one}
88 execsql {INSERT INTO test1(three,one) VALUES(7,8)}
89 execsql {SELECT * FROM test1 ORDER BY one}
95 execsql {
103 execsql {SELECT * from test2}
106 execsql {INSERT INTO test2(f1,f3) VALUES(+10,-10)}
107 execsql {SELECT * FROM test2}
110 execsql {INSERT INTO test2(f2,f4) VALUES(1.23,-3.45)}
111 execsql {SELECT * FROM test2 WHERE f1==-111}
114 execsql {INSERT INTO test2(f1,f2,f4) VALUES(77,+1.23,3.45)}
115 execsql {SELECT * FROM test2 WHERE f1==77}
118 execsql {
128 execsql {SELECT * from test2}
131 execsql {INSERT INTO test2(f2,f4) VALUES(-2.22,'hi!')}
132 execsql {SELECT * FROM test2}
135 execsql {INSERT INTO test2(f1,f5) VALUES(1,'xyzzy')}
136 execsql {SELECT * FROM test2 ORDER BY f1}
144 execsql {
152 execsql {INSERT INTO test2(f2,f4) VALUES(-3.33,'hum')}
153 execsql {SELECT * FROM test2 WHERE f1=111 AND f2=-3.33}
156 execsql {INSERT INTO test2(f1,f2,f5) VALUES(22,-4.44,'wham')}
157 execsql {SELECT * FROM test2 WHERE f1=111 AND f2=-3.33}
160 execsql {SELECT * FROM test2 WHERE f1=22 AND f2=-4.44}
167 execsql {
174 execsql {
186 execsql {
192 execsql {
202 execsql {
212 execsql {
219 execsql {
226 set x [execsql {
234 execsql {
240 execsql {
246 execsql {
253 set x [execsql {
262 execsql {
270 execsql {
276 execsql {
282 execsql {