Lines Matching refs:execsql

23   execsql {CREATE TABLE tbl1(t1 text)}
25     execsql "INSERT INTO tbl1 VALUES('$word')"
27   execsql {SELECT t1 FROM tbl1 ORDER BY t1}
30   execsql {
44   execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
47   set r [catch {execsql {SELECT length(*) FROM tbl1 ORDER BY t1}} msg]
51   set r [catch {execsql {SELECT length(t1,5) FROM tbl1 ORDER BY t1}} msg]
55   execsql {SELECT length(t1), count(*) FROM tbl1 GROUP BY length(t1)
59   execsql {SELECT coalesce(length(a),-1) FROM t2}
65   execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
68   execsql {SELECT substr(t1,2,1) FROM tbl1 ORDER BY t1}
71   execsql {SELECT substr(t1,3,3) FROM tbl1 ORDER BY t1}
74   execsql {SELECT substr(t1,-1,1) FROM tbl1 ORDER BY t1}
77   execsql {SELECT substr(t1,-1,2) FROM tbl1 ORDER BY t1}
80   execsql {SELECT substr(t1,-2,1) FROM tbl1 ORDER BY t1}
83   execsql {SELECT substr(t1,-2,2) FROM tbl1 ORDER BY t1}
86   execsql {SELECT substr(t1,-4,2) FROM tbl1 ORDER BY t1}
89   execsql {SELECT t1 FROM tbl1 ORDER BY substr(t1,2,20)}
92   execsql {SELECT substr(a,1,1) FROM t2}
95   execsql {SELECT substr(a,2,2) FROM t2}
106   execsql {DELETE FROM tbl1}
108     execsql "INSERT INTO tbl1 VALUES('$word')"
110   execsql {SELECT t1 FROM tbl1 ORDER BY t1}
113   execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
116   execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
119   execsql {SELECT substr(t1,1,3) FROM tbl1 ORDER BY t1}
122   execsql {SELECT substr(t1,2,2) FROM tbl1 ORDER BY t1}
125   execsql {SELECT substr(t1,2,3) FROM tbl1 ORDER BY t1}
128   execsql {SELECT substr(t1,3,2) FROM tbl1 ORDER BY t1}
131   execsql {SELECT substr(t1,4,2) FROM tbl1 ORDER BY t1}
134   execsql {SELECT substr(t1,-1,1) FROM tbl1 ORDER BY t1}
137   execsql {SELECT substr(t1,-3,2) FROM tbl1 ORDER BY t1}
140   execsql {SELECT substr(t1,-4,3) FROM tbl1 ORDER BY t1}
143   execsql {DELETE FROM tbl1}
145     execsql "INSERT INTO tbl1 VALUES('$word')"
147   execsql {SELECT t1 FROM tbl1}
155   execsql {
173   execsql {SELECT abs(a) FROM t2}
176   execsql {SELECT abs(t1) FROM tbl1}
201   execsql {SELECT coalesce(round(a,2),'nil') FROM t2}
204   execsql {SELECT round(t1,2) FROM tbl1}
210   execsql {SELECT upper(t1) FROM tbl1}
213   execsql {SELECT lower(upper(t1)) FROM tbl1}
216   execsql {SELECT upper(a), lower(a) FROM t2}
228   execsql {SELECT coalesce(a,'xyz') FROM t2}
231   execsql {SELECT coalesce(upper(a),'nil') FROM t2}
234   execsql {SELECT coalesce(nullif(1,1),'nil')}
237   execsql {SELECT coalesce(nullif(1,2),'nil')}
240   execsql {SELECT coalesce(nullif(1,NULL),'nil')}
247   execsql {SELECT last_insert_rowid()}
253   execsql {
258   execsql {
263   execsql {
269   execsql {
277   execsql {
296   execsql {
304   execsql {
312   execsql {
320   execsql {
341   execsql {