Lines Matching refs:execsql

23   set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3)}} msg]
30   set v [catch {execsql {INSERT INTO sqlite_master VALUES(1,2,3,4)}} msg]
37   execsql {CREATE TABLE test1(one int, two int, three int)}
38   set v [catch {execsql {INSERT INTO test1 VALUES(1,2)}} msg]
42   set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3,4)}} msg]
46   set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1,2,3,4)}} msg]
50   set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1)}} msg]
57   set v [catch {execsql {INSERT INTO test1(one,four) VALUES(1,2)}} msg]
64   execsql {INSERT INTO test1 VALUES(1,2,3)}
65   execsql {SELECT * FROM test1}
68   execsql {INSERT INTO test1 VALUES(4,5,6)}
69   execsql {SELECT * FROM test1 ORDER BY one}
72   execsql {INSERT INTO test1 VALUES(7,8,9)}
73   execsql {SELECT * FROM test1 ORDER BY one}
77   execsql {DELETE FROM test1}
78   execsql {INSERT INTO test1(one,two) VALUES(1,2)}
79   execsql {SELECT * FROM test1 ORDER BY one}
82   execsql {INSERT INTO test1(two,three) VALUES(5,6)}
83   execsql {SELECT * FROM test1 ORDER BY one}
86   execsql {INSERT INTO test1(three,one) VALUES(7,8)}
87   execsql {SELECT * FROM test1 ORDER BY one}
93   execsql {
101   execsql {SELECT * from test2}
104   execsql {INSERT INTO test2(f1,f3) VALUES(+10,-10)}
105   execsql {SELECT * FROM test2}
108   execsql {INSERT INTO test2(f2,f4) VALUES(1.23,-3.45)}
109   execsql {SELECT * FROM test2 WHERE f1==-111}
112   execsql {INSERT INTO test2(f1,f2,f4) VALUES(77,+1.23,3.45)}
113   execsql {SELECT * FROM test2 WHERE f1==77}
116   execsql {
126   execsql {SELECT * from test2}
129   execsql {INSERT INTO test2(f2,f4) VALUES(-2.22,'hi!')}
130   execsql {SELECT * FROM test2}
133   execsql {INSERT INTO test2(f1,f5) VALUES(1,'xyzzy')}
134   execsql {SELECT * FROM test2 ORDER BY f1}
142   execsql {
150   execsql {INSERT INTO test2(f2,f4) VALUES(-3.33,'hum')}
151   execsql {SELECT * FROM test2 WHERE f1=111 AND f2=-3.33}
154   execsql {INSERT INTO test2(f1,f2,f5) VALUES(22,-4.44,'wham')}
155   execsql {SELECT * FROM test2 WHERE f1=111 AND f2=-3.33}
158   execsql {SELECT * FROM test2 WHERE f1=22 AND f2=-4.44}
165   execsql {
172   execsql {
184   execsql {
190   execsql {
200   execsql {
210   execsql {
217   execsql {
224   set x [execsql {
232   execsql {
238   execsql {
244   execsql {
251   set x [execsql {
260   execsql {
268   execsql {
274   execsql {
280   execsql {