Lines Matching refs:execsql
25 execsql {CREATE TABLE tbl1(t1 text)}
27 execsql "INSERT INTO tbl1 VALUES('$word')"
29 execsql {SELECT t1 FROM tbl1 ORDER BY t1}
32 execsql {
46 execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
49 set r [catch {execsql {SELECT length(*) FROM tbl1 ORDER BY t1}} msg]
53 set r [catch {execsql {SELECT length(t1,5) FROM tbl1 ORDER BY t1}} msg]
57 execsql {SELECT length(t1), count(*) FROM tbl1 GROUP BY length(t1)
61 execsql {SELECT coalesce(length(a),-1) FROM t2}
67 execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
70 execsql {SELECT substr(t1,2,1) FROM tbl1 ORDER BY t1}
73 execsql {SELECT substr(t1,3,3) FROM tbl1 ORDER BY t1}
76 execsql {SELECT substr(t1,-1,1) FROM tbl1 ORDER BY t1}
79 execsql {SELECT substr(t1,-1,2) FROM tbl1 ORDER BY t1}
82 execsql {SELECT substr(t1,-2,1) FROM tbl1 ORDER BY t1}
85 execsql {SELECT substr(t1,-2,2) FROM tbl1 ORDER BY t1}
88 execsql {SELECT substr(t1,-4,2) FROM tbl1 ORDER BY t1}
91 execsql {SELECT t1 FROM tbl1 ORDER BY substr(t1,2,20)}
94 execsql {SELECT substr(a,1,1) FROM t2}
97 execsql {SELECT substr(a,2,2) FROM t2}
108 execsql {DELETE FROM tbl1}
110 execsql "INSERT INTO tbl1 VALUES('$word')"
112 execsql {SELECT t1 FROM tbl1 ORDER BY t1}
115 execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
118 execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
121 execsql {SELECT substr(t1,1,3) FROM tbl1 ORDER BY t1}
124 execsql {SELECT substr(t1,2,2) FROM tbl1 ORDER BY t1}
127 execsql {SELECT substr(t1,2,3) FROM tbl1 ORDER BY t1}
130 execsql {SELECT substr(t1,3,2) FROM tbl1 ORDER BY t1}
133 execsql {SELECT substr(t1,4,2) FROM tbl1 ORDER BY t1}
136 execsql {SELECT substr(t1,-1,1) FROM tbl1 ORDER BY t1}
139 execsql {SELECT substr(t1,-3,2) FROM tbl1 ORDER BY t1}
142 execsql {SELECT substr(t1,-4,3) FROM tbl1 ORDER BY t1}
145 execsql {DELETE FROM tbl1}
147 execsql "INSERT INTO tbl1 VALUES('$word')"
149 execsql {SELECT t1 FROM tbl1}
157 execsql {
175 execsql {SELECT abs(a) FROM t2}
178 execsql {SELECT abs(t1) FROM tbl1}
203 execsql {SELECT coalesce(round(a,2),'nil') FROM t2}
206 execsql {SELECT round(t1,2) FROM tbl1}
212 execsql {SELECT upper(t1) FROM tbl1}
215 execsql {SELECT lower(upper(t1)) FROM tbl1}
218 execsql {SELECT upper(a), lower(a) FROM t2}
230 execsql {SELECT coalesce(a,'xyz') FROM t2}
233 execsql {SELECT coalesce(upper(a),'nil') FROM t2}
236 execsql {SELECT coalesce(nullif(1,1),'nil')}
239 execsql {SELECT coalesce(nullif(1,2),'nil')}
242 execsql {SELECT coalesce(nullif(1,NULL),'nil')}
249 execsql {SELECT last_insert_rowid()}
255 execsql {
260 execsql {
265 execsql {
271 execsql {
279 execsql {
298 execsql {
306 execsql {
314 execsql {
322 execsql {
343 execsql {