Lines Matching refs:set
20 set testdir [file dirname $argv0]
27 set DB [sqlite db test.db]
29 set VM [sqlite_compile $DB {SELECT name, rowid FROM sqlite_master} TAIL]
30 set TAIL
36 set N
39 set VALUES
42 set COLNAMES
45 set N x
46 set VALUES y
47 set COLNAMES z
54 set N x
55 set VALUES y
56 set COLNAMES z
70 set SQL {
75 set VM [sqlite_compile $DB $SQL SQL]
76 set SQL
82 set r [sqlite_step $VM n val colname]
86 set r [sqlite_step $VM n val colname]
93 set VM [sqlite_compile $DB $SQL SQL]
94 set SQL
99 set r [sqlite_step $VM n val colname]
106 set VM [sqlite_compile $DB $SQL SQL]
113 set rc [catch {
119 set rc [catch {
125 set rc [catch {
131 set rc [catch {
137 set rc [catch {
143 set rc [catch {
149 set N {}
150 set VALUE {}
151 set COLNAME {}
152 list [sqlite_step $VM N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
159 set VM [sqlite_compile $DB {INSERT INTO t1 VALUES(1,2,3)} TAIL]
160 set TAIL
164 set N {}
165 set VALUE {}
166 set COLNAME {}
167 list [sqlite_step $VM N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
175 list [catch {sqlite_finalize $VM} msg] [set msg]
178 set VM [sqlite_compile $DB {INSERT INTO t1 VALUES(1,3,4)} TAIL]
179 list [sqlite_step $VM N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
183 list [catch {sqlite_finalize $VM} msg] [set msg]
186 set VM [sqlite_compile $DB {CREATE TABLE t2(a NOT NULL, b)} TAIL]
187 set TAIL
190 list [sqlite_step $VM N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
193 list [catch {sqlite_finalize $VM} msg] [set msg]
196 set VM [sqlite_compile $DB {INSERT INTO t2 VALUES(NULL,2)} TAIL]
197 list [sqlite_step $VM N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
200 list [catch {sqlite_finalize $VM} msg] [set msg]
206 set VM1 [sqlite_compile $DB {INSERT INTO t2 VALUES(1,2)} TAIL]
207 set TAIL
210 set VM2 [sqlite_compile $DB {INSERT INTO t2 VALUES(2,3)} TAIL]
211 set TAIL
214 set VM3 [sqlite_compile $DB {INSERT INTO t2 VALUES(3,4)} TAIL]
215 set TAIL
218 list [sqlite_step $VM2 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
224 list [catch {sqlite_finalize $VM2} msg] [set msg]
227 list [sqlite_step $VM3 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
233 list [catch {sqlite_finalize $VM3} msg] [set msg]
236 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
242 list [catch {sqlite_finalize $VM1} msg] [set msg]
248 set VM1 [sqlite_compile $DB {SELECT * FROM t2} TAIL]
249 set VM2 [sqlite_compile $DB {SELECT * FROM t2} TAIL]
250 set VM3 [sqlite_compile $DB {SELECT * FROM t2} TAIL]
251 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
254 list [sqlite_step $VM2 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
257 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
260 list [sqlite_step $VM3 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
263 list [sqlite_step $VM3 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
266 list [sqlite_step $VM3 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
269 list [sqlite_step $VM3 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
272 list [catch {sqlite_finalize $VM3} msg] [set msg]
275 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
278 list [catch {sqlite_finalize $VM1} msg] [set msg]
281 list [sqlite_step $VM2 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
284 list [sqlite_step $VM2 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
287 list [catch {sqlite_finalize $VM2} msg] [set msg]
303 set VM1 [sqlite_compile $DB {SELECT * FROM t3} TAIL]
308 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
314 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
320 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
326 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
332 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
338 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
345 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
347 # puts [list [catch {sqlite_finalize $VM1} msg] [set msg]]; exit
352 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
358 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
364 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
370 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
376 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
385 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
394 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
397 list [catch {sqlite_finalize $VM1} msg] [set msg]
456 set x [stepsql $DB {EXPLAIN SELECT * FROM t1}]
463 set VM1 [sqlite_compile $DB {SELECT * FROM t2} TAIL]
471 set VM1 [sqlite_compile $DB {SELECT * FROM t2}]