public SQLJoinTable(string maintable, SQLVars selectfields, SQLWhereVars wherefields) : base(maintable, selectfields, wherefields)
{
}
public SQLSelectTable(string maintab, SQLVars selfield, SQLWhereVars wherefield, SQLVars groupby, SQLOrderVars orderbyfields) : this(maintab, selfield, wherefield, groupby)
{
OrderByFields = orderbyfields;
}
public SQLJoinTable(string maintable, List <string> jointables, List <SQLJoinFields> joinfields, SQLVars selectfields, SQLWhereVars wherefields) : base(maintable, selectfields, wherefields)
{
if (jointables.Count == joinfields.Count)
{
JoinTables = jointables;
JoinFields = joinfields;
}
}
public SQLSelectTable(string maintab, SQLVars selfield, SQLWhereVars wherefield) : this(maintab, selfield)
{
WhereFields = wherefield;
}
public SQLSelectTable(string maintab, SQLVars selfield, SQLWhereVars wherefield, SQLVars groupby) : this(maintab, selfield, wherefield)
{
GroupBy = groupby;
}
public SQLDeleteTable(string table, SQLWhereVars where, bool allfields) : this(table, where)
{
AllFields = allfields;
}
public SQLSelectTable(string maintab, string selectfield, SQLWhereVars wherefields) : this(maintab, selectfield)
{
WhereFields = wherefields;
}
public SQLSelectBetweenTable(string maintable, SQLVars selectfields, SQLWhereVars wherefields, bool unot = false) : base(maintable, selectfields, wherefields)
{
usenot = unot;
}
public SQLDeleteTable(string table, SQLWhereVars where) : this(table)
{
WhereFields = where;
}
public SQLCreateView(string maintable, SQLVars selectfields, SQLWhereVars wherefields, string viewname) : base(maintable, selectfields, wherefields)
{
SetViewName(viewname);
}
public void AddSelectTable(string maintable, List <string> jointables, List <SQLJoinFields> joinfields, SQLVars selectfields, SQLWhereVars wherefields)
{
SelectTable = new SQLJoinTable(maintable, jointables, joinfields, selectfields, wherefields);
}
public void AddSelectTable(string maintable, SQLVars selectfields, SQLWhereVars wherefields)
{
SelectTable = new SQLJoinTable(maintable, selectfields, wherefields);
}
public SQLUpdateTable(string tablename, SQLVarsVals vars, SQLWhereVars where) : this(tablename, vars)
{
WhereFields = where;
}
public SQLSelectIntoTable(string maintable, List <string> jointables, List <SQLJoinFields> joinfields, SQLVars selectfields, SQLWhereVars wherefields, string destinationtable = "", string externaldb = "") : base(maintable, jointables, joinfields, selectfields, wherefields)
{
DestinationTable = destinationtable;
ExternalDB = externaldb;
}