Parameters
- condition
- A new condition to add.
SQLiteSelectStatement stmt = new SQLiteSelectStatement(); stmt.Columns.Add(new SelectColumn("ENAME")); stmt.Tables.Add(new SelectTable("emp")); stmt.Where = "1000 < SAL"; stmt.AddWhereCondition("SAL < 1500"); stmt.AddWhereCondition("JOB = 'SALESMAN'"); //select ENAME from emp where ((1000 < SAL) AND SAL < 1500 ) AND JOB = 'SALESMAN' SQLiteCommand command = new SQLiteCommand(stmt.ToString());
Dim stmt As New SQLiteSelectStatement stmt.Columns.Add(New SelectColumn("ENAME")) stmt.Tables.Add(New SelectTable("emp")) stmt.Where = "1000 < SAL" stmt.AddWhereCondition("SAL < 1500") stmt.AddWhereCondition("JOB = 'SALESMAN'") 'select ENAME from emp where ((1000 < SAL) AND SAL < 1500 ) AND JOB = 'SALESMAN' Dim command As New SQLiteCommand(stmt.ToString)