/// <summary>
/// This method builds a SQL Select statement to perfrom on the SQLite DB
/// </summary>
/// <param name="TableName">The name of the table to be queried</param>
/// <param name="SelectFields">A variable that contains multiple fields to select from the table</param>
/// <param name="Variables">Contains the variables and values for the WHERE portion of the query</param>
/// <param name="separator">In case a different separator is wanted for the query than a comma</param>
public void DoQuery(string TableName, SQLVars SelectFields, SQLWhereVars Variables, string separator = ", ")
{
SQLSelectTable table = new SQLSelectTable(TableName, SelectFields, Variables);
DoSelectCommand(table);//.GetSql(), table.GetWhereFields());
//string fields = SelectFields.GetFieldNames(separator);
//DoQuery(TableName, fields, Variables, separator);
}
public SQLiteInsert(SQLiteConnection sqlcon, string TableName, SQLVars Fields, List <SQLVars> Values)
{
SQLInsertTableMultiValues table = new SQLInsertTableMultiValues(TableName, Fields, Values);
DoInsertCommand(sqlcon, table);//.GetSql());
}