Lines Matching refs:f1

21 execsql {CREATE TABLE tbl1(f1 int, f2 int)}
31   set sql {SELECT DISTINCT f1 FROM tbl1 ORDER BY f1}
35     set f1 $data(f1)
36     lappend r $f1:
37     set sql2 "SELECT f2 FROM tbl1 WHERE f1=$f1 ORDER BY f2"
46   set sql {SELECT DISTINCT f1 FROM tbl1 WHERE f1>3 AND f1<5}
49     set f1 $data(f1)
50     lappend r $f1:
51     set sql2 "SELECT f2 FROM tbl1 WHERE f1=$f1 ORDER BY f2"
67       execsql {CREATE TABLE tbl2(f1 int, f2 int, f3 int); BEGIN;}
82     execsql {CREATE TABLE tbl2(f1 int, f2 int, f3 int); BEGIN;}
107   execsql {SELECT f1 FROM tbl2 WHERE 1000=f2}
114   execsql {SELECT f1 FROM tbl2 WHERE 1000=f2}
117   execsql {SELECT f1 FROM tbl2 WHERE f2=1000}
135   execsql {SELECT f1 FROM tbl2 WHERE f2==2000}