'Declaration Public ReadOnly Property Columns As SelectColumnCollection
public SelectColumnCollection Columns {get;}
'Declaration Public ReadOnly Property Columns As SelectColumnCollection
public SelectColumnCollection Columns {get;}
private void RefreshStatement(OracleSelectStatement 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 OracleSelectStatement) 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