'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(MySqlSelectStatement 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 MySqlSelectStatement) 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