Lines Matching refs:f1
22 execsql {CREATE TABLE tbl1(f1 int, f2 int)}
35 set sql {SELECT DISTINCT f1 FROM tbl1 ORDER BY f1}
38 set f1 $data(f1)
39 lappend r $f1:
40 set sql2 "SELECT f2 FROM tbl1 WHERE f1=$f1 ORDER BY f2"
49 set sql {SELECT DISTINCT f1 FROM tbl1 WHERE f1>3 AND f1<5}
52 set f1 $data(f1)
53 lappend r $f1:
54 set sql2 "SELECT f2 FROM tbl1 WHERE f1=$f1 ORDER BY f2"
65 execsql {CREATE TABLE tbl2(f1 int, f2 int, f3 int)}
84 execsql {SELECT f1 FROM tbl2 WHERE 1000=f2}
92 execsql {SELECT f1 FROM tbl2 WHERE 1000=f2}
95 execsql {SELECT f1 FROM tbl2 WHERE f2=1000}
113 execsql {SELECT f1 FROM tbl2 WHERE f2==2000}