public SQLSelectQuery(SQLSelectQuery query)
{
this.IsDistinct = query.IsDistinct;
foreach(string column in query._selectedColumns) {
this._selectedColumns.Add(column);
}
foreach (string column in query._selectedTables) {
this._selectedTables.Add(column);
}
this._whereStatement = WhereStatement.Copy(query._whereStatement);
foreach (OrderByClause clause in query._orderByStatement) {
this._orderByStatement.Add(clause);
}
foreach (string column in query._groupByColumns) {
this._groupByColumns.Add(column);
}
this._havingStatement = WhereStatement.Copy(query._havingStatement);
if (query._limitStatement != null)
this._limitStatement = new LimitClause(query._limitStatement.From, query._limitStatement.To);
}
public void LimitClear()
{
_limitStatement = null;
}
public void AddLimit(int from, int to)
{
_limitStatement = new LimitClause(from, to);
}
