'Declaration Public ReadOnly Property Tables As SelectTableCollection
public SelectTableCollection Tables {get;}
'Declaration Public ReadOnly Property Tables As SelectTableCollection
public SelectTableCollection Tables {get;}
private void RefreshStatement(SQLiteSelectStatement stmt) { stmt.Clear(); stmt.Columns.Add(new SelectColumn("ENAME")); stmt.Columns.Add(new SelectColumn("", "emp", "JOB", "j")); stmt.Columns.Add(new SelectColumn("test", "", "emp", "HIREDATE", "hd")); stmt.Tables.Add(new SelectTable("emp")); //select ENAME,emp.JOB j,emp.HIREDATE hd from emp string queryText = stmt.ToString(); }
Private Sub RefreshStatement(ByVal stmt As SQLiteSelectStatement) stmt.Clear() stmt.Columns.Add(New SelectColumn("ENAME")) stmt.Columns.Add(New SelectColumn("", "emp", "JOB", "j")) stmt.Columns.Add(New SelectColumn("test", "", "emp", "HIREDATE", "hd")) stmt.Tables.Add(New SelectTable("emp")) 'select ENAME,emp.JOB j,emp.HIREDATE hd from emp Dim queryText As String = stmt.ToString End Sub