Lines Matching refs:set
18 set testdir [file dirname $argv0]
25 set DB [sqlite db test.db]
27 set VM [sqlite_compile $DB {SELECT name, rowid FROM sqlite_master} TAIL]
28 set TAIL
34 set N
37 set VALUES
40 set COLNAMES
43 set N x
44 set VALUES y
45 set COLNAMES z
52 set N x
53 set VALUES y
54 set COLNAMES z
68 set SQL {
73 set VM [sqlite_compile $DB $SQL SQL]
74 set SQL
80 set r [sqlite_step $VM n val colname]
84 set r [sqlite_step $VM n val colname]
91 set VM [sqlite_compile $DB $SQL SQL]
92 set SQL
97 set r [sqlite_step $VM n val colname]
104 set VM [sqlite_compile $DB $SQL SQL]
111 set rc [catch {
117 set rc [catch {
123 set rc [catch {
129 set rc [catch {
135 set rc [catch {
141 set rc [catch {
147 set N {}
148 set VALUE {}
149 set COLNAME {}
150 list [sqlite_step $VM N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
157 set VM [sqlite_compile $DB {INSERT INTO t1 VALUES(1,2,3)} TAIL]
158 set TAIL
162 set N {}
163 set VALUE {}
164 set COLNAME {}
165 list [sqlite_step $VM N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
173 list [catch {sqlite_finalize $VM} msg] [set msg]
176 set VM [sqlite_compile $DB {INSERT INTO t1 VALUES(1,3,4)} TAIL]
177 list [sqlite_step $VM N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
181 list [catch {sqlite_finalize $VM} msg] [set msg]
184 set VM [sqlite_compile $DB {CREATE TABLE t2(a NOT NULL, b)} TAIL]
185 set TAIL
188 list [sqlite_step $VM N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
191 list [catch {sqlite_finalize $VM} msg] [set msg]
194 set VM [sqlite_compile $DB {INSERT INTO t2 VALUES(NULL,2)} TAIL]
195 list [sqlite_step $VM N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
198 list [catch {sqlite_finalize $VM} msg] [set msg]
204 set VM1 [sqlite_compile $DB {INSERT INTO t2 VALUES(1,2)} TAIL]
205 set TAIL
208 set VM2 [sqlite_compile $DB {INSERT INTO t2 VALUES(2,3)} TAIL]
209 set TAIL
212 set VM3 [sqlite_compile $DB {INSERT INTO t2 VALUES(3,4)} TAIL]
213 set TAIL
216 list [sqlite_step $VM2 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
222 list [catch {sqlite_finalize $VM2} msg] [set msg]
225 list [sqlite_step $VM3 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
231 list [catch {sqlite_finalize $VM3} msg] [set msg]
234 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
240 list [catch {sqlite_finalize $VM1} msg] [set msg]
246 set VM1 [sqlite_compile $DB {SELECT * FROM t2} TAIL]
247 set VM2 [sqlite_compile $DB {SELECT * FROM t2} TAIL]
248 set VM3 [sqlite_compile $DB {SELECT * FROM t2} TAIL]
249 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
252 list [sqlite_step $VM2 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
255 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
258 list [sqlite_step $VM3 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
261 list [sqlite_step $VM3 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
264 list [sqlite_step $VM3 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
267 list [sqlite_step $VM3 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
270 list [catch {sqlite_finalize $VM3} msg] [set msg]
273 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
276 list [catch {sqlite_finalize $VM1} msg] [set msg]
279 list [sqlite_step $VM2 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
282 list [sqlite_step $VM2 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
285 list [catch {sqlite_finalize $VM2} msg] [set msg]
301 set VM1 [sqlite_compile $DB {SELECT * FROM t3} TAIL]
306 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
312 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
318 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
324 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
330 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
336 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
343 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
345 # puts [list [catch {sqlite_finalize $VM1} msg] [set msg]]; exit
350 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
356 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
362 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
368 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
374 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
383 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
392 list [sqlite_step $VM1 N VALUE COLNAME] [set N] [set VALUE] [set COLNAME]
395 list [catch {sqlite_finalize $VM1} msg] [set msg]
454 set x [stepsql $DB {EXPLAIN SELECT * FROM t1}]
461 set VM1 [sqlite_compile $DB {SELECT * FROM t2} TAIL]
469 set VM1 [sqlite_compile $DB {SELECT * FROM t2}]