Lines Matching refs:f1
24 execsql {CREATE TABLE tbl1(f1 int, f2 int)}
37 set sql {SELECT DISTINCT f1 FROM tbl1 ORDER BY f1}
40 set f1 $data(f1)
41 lappend r $f1:
42 set sql2 "SELECT f2 FROM tbl1 WHERE f1=$f1 ORDER BY f2"
51 set sql {SELECT DISTINCT f1 FROM tbl1 WHERE f1>3 AND f1<5}
54 set f1 $data(f1)
55 lappend r $f1:
56 set sql2 "SELECT f2 FROM tbl1 WHERE f1=$f1 ORDER BY f2"
67 execsql {CREATE TABLE tbl2(f1 int, f2 int, f3 int)}
86 execsql {SELECT f1 FROM tbl2 WHERE 1000=f2}
94 execsql {SELECT f1 FROM tbl2 WHERE 1000=f2}
97 execsql {SELECT f1 FROM tbl2 WHERE f2=1000}
115 execsql {SELECT f1 FROM tbl2 WHERE f2==2000}