Lines Matching refs:execsql
25 execsql {
31 execsql {
43 execsql {SELECT name, tbl_name, type FROM sqlite_master WHERE type!='meta'}
52 execsql {SELECT name, tbl_name, type from sqlite_master WHERE type!='meta'}
58 execsql {DROP TABLE test1}
59 execsql {SELECT * FROM sqlite_master WHERE type!='meta'}
68 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
74 execsql {CREATE TABLE "create" (f1 int)}
75 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
78 execsql {DROP TABLE "create"}
79 execsql {SELECT name FROM "sqlite_master" WHERE type!='meta'}
82 execsql {CREATE TABLE test1("f1 ho" int)}
83 execsql {SELECT name as "X" FROM sqlite_master WHERE type!='meta'}
86 execsql {DROP TABLE "TEST1"}
87 execsql {SELECT name FROM "sqlite_master" WHERE type!='meta'}
95 execsql {CREATE TABLE TEST2(one text)}
96 set v [catch {execsql {CREATE TABLE test2(two text)}} msg]
100 set v [catch {execsql {CREATE TABLE sqlite_master(two text)}} msg]
106 set v [catch {execsql {CREATE TABLE sqlite_master(two text)}} msg]
110 execsql {DROP TABLE test2; SELECT name FROM sqlite_master WHERE type!='meta'}
116 execsql {CREATE TABLE test2(one text); CREATE INDEX test3 ON test2(one)}
117 set v [catch {execsql {CREATE TABLE test3(two text)}} msg]
123 set v [catch {execsql {CREATE TABLE test3(two text)}} msg]
127 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
130 execsql {DROP INDEX test3}
131 set v [catch {execsql {CREATE TABLE test3(two text)}} msg]
135 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
138 execsql {DROP TABLE test2; DROP TABLE test3}
139 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
168 execsql $big_table
169 execsql {SELECT sql FROM sqlite_master WHERE type=='table'}
172 set v [catch {execsql {CREATE TABLE BIG(xyz foo)}} msg]
176 set v [catch {execsql {CREATE TABLE biG(xyz foo)}} msg]
180 set v [catch {execsql {CREATE TABLE bIg(xyz foo)}} msg]
186 set v [catch {execsql {CREATE TABLE Big(xyz foo)}} msg]
190 execsql {DROP TABLE big}
191 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
207 execsql $sql
209 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
214 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
225 # if {$i==38} {execsql {pragma vdbe_trace=on}}
227 execsql $sql
229 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
238 execsql $sql
240 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
246 set v [catch {execsql {DROP TABLE test009}} msg]
253 set v [catch {execsql {DROP TABLE sqlite_master}} msg]
260 execsql {EXPLAIN CREATE TABLE test1(f1 int)}
261 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
267 execsql {CREATE TABLE test1(f1 int)}
268 execsql {EXPLAIN DROP TABLE test1}
269 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
275 # execsql {CREATE TABLE 'Spaces In This Name!'(x int)}
276 # execsql {INSERT INTO 'spaces in this name!' VALUES(1)}
283 set v [catch {execsql {
297 execsql {
317 execsql {
330 execsql {
343 execsql {
482 execsql {
500 execsql {