Lines Matching refs:execsql

23   execsql {
29   execsql {
41   execsql {SELECT name, tbl_name, type FROM sqlite_master WHERE type!='meta'}
50   execsql {SELECT name, tbl_name, type from sqlite_master WHERE type!='meta'}
56   execsql {DROP TABLE test1}
57   execsql {SELECT * FROM sqlite_master WHERE type!='meta'}
66   execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
72   execsql {CREATE TABLE "create" (f1 int)}
73   execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
76   execsql {DROP TABLE "create"}
77   execsql {SELECT name FROM "sqlite_master" WHERE type!='meta'}
80   execsql {CREATE TABLE test1("f1 ho" int)}
81   execsql {SELECT name as "X" FROM sqlite_master WHERE type!='meta'}
84   execsql {DROP TABLE "TEST1"}
85   execsql {SELECT name FROM "sqlite_master" WHERE type!='meta'}
93   execsql {CREATE TABLE TEST2(one text)}
94   set v [catch {execsql {CREATE TABLE test2(two text)}} msg]
98   set v [catch {execsql {CREATE TABLE sqlite_master(two text)}} msg]
104   set v [catch {execsql {CREATE TABLE sqlite_master(two text)}} msg]
108   execsql {DROP TABLE test2; SELECT name FROM sqlite_master WHERE type!='meta'}
114   execsql {CREATE TABLE test2(one text); CREATE INDEX test3 ON test2(one)}
115   set v [catch {execsql {CREATE TABLE test3(two text)}} msg]
121   set v [catch {execsql {CREATE TABLE test3(two text)}} msg]
125   execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
128   execsql {DROP INDEX test3}
129   set v [catch {execsql {CREATE TABLE test3(two text)}} msg]
133   execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
136   execsql {DROP TABLE test2; DROP TABLE test3}
137   execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
166   execsql $big_table
167   execsql {SELECT sql FROM sqlite_master WHERE type=='table'}
170   set v [catch {execsql {CREATE TABLE BIG(xyz foo)}} msg]
174   set v [catch {execsql {CREATE TABLE biG(xyz foo)}} msg]
178   set v [catch {execsql {CREATE TABLE bIg(xyz foo)}} msg]
184   set v [catch {execsql {CREATE TABLE Big(xyz foo)}} msg]
188   execsql {DROP TABLE big}
189   execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
205     execsql $sql
207   execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
212   execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
223     # if {$i==38} {execsql {pragma vdbe_trace=on}}
225     execsql $sql
227   execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
236     execsql $sql
238   execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
244   set v [catch {execsql {DROP TABLE test009}} msg]
251   set v [catch {execsql {DROP TABLE sqlite_master}} msg]
258   execsql {EXPLAIN CREATE TABLE test1(f1 int)}
259   execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
265   execsql {CREATE TABLE test1(f1 int)}
266   execsql {EXPLAIN DROP TABLE test1}
267   execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
273 #  execsql {CREATE TABLE 'Spaces In This Name!'(x int)}
274 #  execsql {INSERT INTO 'spaces in this name!' VALUES(1)}
281   set v [catch {execsql {
295   execsql {
315   execsql {
328   execsql {
341   execsql {
480   execsql {
498   execsql {