Parameters
- condition
- A new condition to add.
SQLiteSelectStatement stmt = new SQLiteSelectStatement(); stmt.Columns.Add(new SelectColumn("EMP")); stmt.Columns.Add(new SelectColumn("SAL")); stmt.Tables.Add(new SelectTable("emp")); stmt.AddHavingCondition("SAL > 1000"); //select JOB,SAL from emp having SAL > 1000 SQLiteCommand command = new SQLiteCommand(stmt.ToString());
Dim stmt As New SQLiteSelectStatement stmt.Columns.Add(New SelectColumn("EMP")) stmt.Columns.Add(New SelectColumn("SAL")) stmt.Tables.Add(New SelectTable("emp")) stmt.AddHavingCondition("SAL > 1000") 'select JOB,SAL from emp having SAL > 1000 Dim command As New SQLiteCommand(stmt.ToString)