'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(SqlSelectStatement 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,Test.emp.HIREDATE hd from emp string queryText = stmt.ToString(); }
Private Sub RefreshStatement(ByVal stmt As SqlSelectStatement) 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,Test.emp.HIREDATE hd from emp Dim queryText As String = stmt.ToString End Sub