// +CreateSymbolByName(SymbolName : string = "UNKNOWN", AcceptDuplicates : boolean = 0, ResultedSymbol : List<int[2]>) public List<SObject> CreateSymbolByName(string SymbolName, bool AcceptDuplicates) { if (!AcceptDuplicates) { List<SObject> ExistentSymbols = GetSymbolsByName(SymbolName, 0, 10); if (ExistentSymbols.Count > 0) return ExistentSymbols; } List<SObject> ResultedSymbols = new List<SObject>(); int[] symbolPosition = { 0, 0, 0, 0 }; try { //DEFAULT und NULL sind nicht als explizite Identitätswerte zulässig string commandString = "INSERT INTO [simbs] ([En]) OUTPUT INSERTED.ID VALUES ('" + SymbolName + "') "; SqlCommand mySqlCommand = new SqlCommand(commandString, SqlServerConnection); SqlDataReader myReader = mySqlCommand.ExecuteReader(); int LastInsertedId = 0; //if (MySqlTrace) SQLView.Log(mySqlCommand.CommandText); while (myReader.Read()) { if (myReader.GetInt32(0) > -1) { SObject symbolID = new SObject(); LastInsertedId = myReader.GetInt32(0); symbolID.ObjectId = LastInsertedId; if (symbolID.ObjectId != 0 || symbolID.ObjectId != 0) { ResultedSymbols.Add(symbolID); } } } myReader.Close(); //if (SqlTrace) SQLView.Log(mySqlCommand.CommandText); if (LastInsertedId > 0) { string commandString2 = "UPDATE [simbs] SET [IR] = [ID] WHERE [ID] = " + LastInsertedId + " ;"; SqlCommand mySqlCommand2 = new SqlCommand(commandString2, SqlServerConnection); mySqlCommand2.ExecuteNonQuery(); symbolPosition[0] = LastInsertedId; //ResultedSymbols.Add(symbolPosition); } } catch (SqlException retrieveSymbolIndexException) { Console.WriteLine("Error: {0}", retrieveSymbolIndexException.ToString()); } CreateSymbolTable(symbolPosition); //if (MyResultsTrace) SQLView.LogResult(symbolPosition); return ResultedSymbols; }
//public List<string> GetSymbolNamesByID(int[] SymbolID, int Mode = 0, int LimitOfResults = 10); //GetSymbolNamesByID = ServerAccessInterface.GetSymbolNamesByID; #endregion Adapter #region Interface Helpers #region create symbol table /// <summary> /// Create a nonexistent table and rezerve first line with id 1 /// </summary> /// <param name="symbolPosition">position of table reference in simbols table can be used to decode the table name</param> private void CreateSymbolTable(SObject symbolPosition) { string commandString = "CREATE TABLE IF NOT EXISTS `" + DB + "`.`s" + symbolPosition.ObjectId.ToString("00000000") + "` ( `ID` INT NOT NULL AUTO_INCREMENT , `a` INT NULL , `b` INT NULL , `c` INT NULL , `d` INT NULL , `e` INT NULL , `f` INT NULL , `g` INT NULL , `h` INT NULL , PRIMARY KEY (`ID`) );"; MySql.Data.MySqlClient.MySqlCommand mySqlCommand = new MySqlCommand(commandString, mySQLConnection); mySqlCommand.ExecuteNonQuery(); //if (MySqlTrace) SQLView.Log(mySqlCommand.CommandText); commandString = "INSERT INTO `" + DB + "`.`s" + symbolPosition.ObjectId.ToString("00000000") + "` (`a`, `b`, `c`, `d`, `e`, `f`, `g`, `h`) VALUES (0,0,0,0,0,0,0,0) ;"; mySqlCommand = new MySqlCommand(commandString, mySQLConnection); mySqlCommand.ExecuteNonQuery(); //if (MySqlTrace) SQLView.Log(mySqlCommand.CommandText); }
// +GetSymbolsByName(SymbolsNamePart : string = "", Method : int = 0, LimitOfResults : int = 10, ResultedSymbols : List<int[2]>) public List<SObject> GetSymbolsByName(string SymbolNamePart, int Mode, int LimitOfResults = 10) { List<SObject> ResultedSymbols = new List<SObject>(); try { string commandString; switch (Mode) { case 0: // strict commandString = "SELECT [IR] FROM [simbs] WHERE [En] LIKE '" + SymbolNamePart + "' "; break; case 1: // starting with commandString = "SELECT [IR] FROM [simbs] WHERE [En] LIKE '" + SymbolNamePart + "%' "; break; case 2: // containing commandString = "SELECT [IR] FROM [simbs] WHERE [En] LIKE '%" + SymbolNamePart + "%' "; break; case 3: // ending with commandString = "SELECT [IR] FROM [simbs] WHERE [En] LIKE '%" + SymbolNamePart + "' "; break; default: commandString = "SELECT [IR] FROM [simbs] WHERE [En] LIKE '" + SymbolNamePart + "' "; break; } //if (LimitOfResults != 0) { commandString += " Limit " + LimitOfResults + " "; } SqlCommand mySqlCommand = new SqlCommand(commandString, SqlServerConnection); SqlDataReader myReader = mySqlCommand.ExecuteReader(); //if (MySqlTrace) SQLView.Log(mySqlCommand.CommandText); while (myReader.Read()) { if (myReader.GetInt32(0) > -1) { SObject symbolID = new SObject(); symbolID.ObjectId = myReader.GetInt32(0); if (symbolID.ObjectId != 0 || symbolID.ObjectId != 0) { ResultedSymbols.Add(symbolID); } } } myReader.Close(); } catch (SqlException retrieveSymbolIndexException) { Console.WriteLine("Error: {0}", retrieveSymbolIndexException.ToString()); } if (MyResultsTrace) { string ResultLog = ""; foreach (SObject i in ResultedSymbols) { ResultLog += " [" + i.ObjectId + ":" + "0" + "]"; } //SQLView.LogResult(new string[] { ResultLog }); } if (ResultedSymbols.Count < 1 && Mode == 0 && AcceptSymbols) { List<SObject> CreatedSymbols = new List<SObject>(); CreatedSymbols = CreateSymbolByName(SymbolNamePart, true); return CreatedSymbols; } return ResultedSymbols; }
// +GetSymbolsByName(SymbolsNamePart : string = "", Method : int = 0, LimitOfResults : int = 10, ResultedSymbols : List<int[2]>) public List<SObject> GetSymbolsByName(string SymbolNamePart, int Mode, int LimitOfResults = 10) { List<SObject> ResultedSymbols = new List<SObject>(); try { string commandString; switch (Mode) { case 0: // strict commandString = "SELECT `IR` FROM `" + DB + "`.`simbs` WHERE `En` LIKE '" + SymbolNamePart + "' "; break; case 1: // starting with commandString = "SELECT `IR` FROM `" + DB + "`.`simbs` WHERE `En` LIKE '" + SymbolNamePart + "%' "; break; case 2: // containing commandString = "SELECT `IR` FROM `" + DB + "`.`simbs` WHERE `En` LIKE '%" + SymbolNamePart + "%' "; break; case 3: // ending with commandString = "SELECT `IR` FROM `" + DB + "`.`simbs` WHERE `En` LIKE '%" + SymbolNamePart + "' "; break; default: commandString = "SELECT `IR` FROM `" + DB + "`.`simbs` WHERE `En` LIKE '" + SymbolNamePart + "' "; break; } if (LimitOfResults != 0) { commandString += " Limit " + LimitOfResults + " "; } MySql.Data.MySqlClient.MySqlCommand mySqlCommand = new MySqlCommand(commandString, mySQLConnection); MySqlDataReader myReader = mySqlCommand.ExecuteReader(); //if (MySqlTrace) SQLView.Log(mySqlCommand.CommandText); while (myReader.Read()) { if (!string.IsNullOrEmpty(myReader.GetString(0))) //TO DO null value { SObject symbolID = new SObject(); int temporarId = -1; int.TryParse(myReader.GetString(0), out temporarId); symbolID.ObjectId = temporarId; if (symbolID.ObjectId != 0 || symbolID.ObjectId != 0) { ResultedSymbols.Add(symbolID); } } } myReader.Close(); } catch (MySqlException retrieveSymbolIndexException) { Console.WriteLine("Error: {0}", retrieveSymbolIndexException.ToString()); } if (MyResultsTrace) { string ResultLog = ""; foreach (SObject i in ResultedSymbols) { ResultLog += " [" + i.ObjectId + ":" + "0" + "]"; } //SQLView.LogResult(new string[] { ResultLog }); } if (ResultedSymbols.Count < 1 && Mode == 0 && AcceptSymbols) { List<SObject> CreatedSymbols = new List<SObject>(); CreatedSymbols = CreateSymbolByName(SymbolNamePart, true); // set AcceptDuplicates to avoid other check for existence return CreatedSymbols; } return ResultedSymbols; }
// +CreateSymbolByName(SymbolName : string = "UNKNOWN", AcceptDuplicates : boolean = 0, ResultedSymbol : List<int[2]>) public List<SObject> CreateSymbolByName(string SymbolName, bool AcceptDuplicates) { if (! AcceptDuplicates) { List<SObject> ExistentSymbols = GetSymbolsByName(SymbolName, 0, 10); if (ExistentSymbols.Count > 0) return ExistentSymbols; } List<SObject> ResultedSymbols = new List<SObject>(); SObject symbolPosition = new SObject(); try { string commandString = "INSERT INTO `" + DB + "`.`simbs` (`ID`, `En`) VALUES (NULL, '" + SymbolName + "');"; MySql.Data.MySqlClient.MySqlCommand mySqlCommand = new MySqlCommand(commandString, mySQLConnection); mySqlCommand.ExecuteNonQuery(); //if (MySqlTrace) SQLView.Log(mySqlCommand.CommandText); if (mySqlCommand.LastInsertedId > 0) { string commandString2 = "UPDATE `" + DB + "`.`simbs` SET `IR` = `ID` WHERE `ID` = " + (int)mySqlCommand.LastInsertedId + " ;"; MySql.Data.MySqlClient.MySqlCommand mySqlCommand2 = new MySqlCommand(commandString2, mySQLConnection); mySqlCommand2.ExecuteNonQuery(); symbolPosition.ObjectId = (int)mySqlCommand.LastInsertedId; ResultedSymbols.Add(symbolPosition); } } catch (MySqlException retrieveSymbolIndexException) { Console.WriteLine("Error: {0}", retrieveSymbolIndexException.ToString()); } CreateSymbolTable(symbolPosition); //if (MyResultsTrace) SQLView.LogResult(symbolPosition); return ResultedSymbols; }
// +CreateSymbolByName(SymbolName : string = "UNKNOWN", AcceptDuplicates : boolean = 0, ResultedSymbol : List<int[2]>) public List<SObject> CreateSymbolByName(string SymbolName, bool AcceptDuplicates) { //=== CUSTOM LOGGER=================================================================================== //if (LoggingSystem.LoggingSystem.TraceCode) { System.Diagnostics.StackTrace stackTrace; System.Diagnostics.StackFrame fr; stackTrace = new System.Diagnostics.StackTrace(); fr = stackTrace.GetFrame(0); //LoggingSystem.LoggingSystem.LogMessage = "<div class='CodeElementNamespace'> " + this.GetType().Namespace + " <span class='CodeElementClass'> " + this.GetType().Name + " </span>> " + stackTrace.GetFrame(0).GetMethod().ToString().Replace(stackTrace.GetFrame(0).GetMethod().Name, "<span class='CodeElementMethod'>" + stackTrace.GetFrame(0).GetMethod().Name + "</span>"); //LoggingSystem.LoggingSystem.LogMessage = "<span class='specialChaer'>(" + "<span class='CodeElementParameter'>string</span> " + "<span class='CodeElementValue'>" + SymbolName + "</span>" + ", <span class='CodeElementParameter'>bool</span> " + "<span class='CodeElementValue'>" + AcceptDuplicates + "</span>)</span></div>"; } //==================================================================================================== if (!AcceptDuplicates) { List<SObject> ExistentSymbols = GetSymbolsByName(SymbolName, 0, 10); if (ExistentSymbols.Count > 0) return ExistentSymbols; } List<SObject> ResultedSymbols = new List<SObject>(); SObject symbolPosition = new SObject(); try { string commandString = "INSERT INTO " + OracleDB + ".SIMBS (ID, EN) VALUES (NULL, '" + SymbolName + "') RETURNING SIMBS.ID INTO :LastID "; OracleCommand OracleCommand = new OracleCommand(commandString, OracleConnection); OracleParameter LastId = new OracleParameter("LastID", OracleDbType.Decimal, ParameterDirection.ReturnValue); OracleCommand.Parameters.Add(LastId); //if (MySqlTrace) SQLView.Log(mySqlCommand.CommandText); OracleDataReader myReader = OracleCommand.ExecuteReader(); int LastInsertedId = 0; int.TryParse(LastId.Value.ToString(), out LastInsertedId); if (LastInsertedId > 0) { string commandString2 = "UPDATE " + OracleDB + ".SIMBS SET IR = ID WHERE ID = " + LastInsertedId + " "; OracleCommand mySqlCommand2 = new OracleCommand(commandString2, OracleConnection); mySqlCommand2.ExecuteNonQuery(); symbolPosition.ObjectId = LastInsertedId; ResultedSymbols.Add(symbolPosition); } ////if (OracleTrace) SQLView.Log(OracleCommand.CommandText); } catch (OracleException retrieveSymbolIndexException) { Console.WriteLine("Error: {0}", retrieveSymbolIndexException.ToString()); } CreateSymbolTable(symbolPosition); //if (MyResultsTrace)//SQLView.LogResult(symbolPosition); return ResultedSymbols; }
// +GetSymbolsByName(SymbolsNamePart : string = "", Method : int = 0, LimitOfResults : int = 10, ResultedSymbols : List<int[2]>) public List<SObject> GetSymbolsByName(string SymbolNamePart, int Mode, int LimitOfResults = 10) { List<SObject> ResultedSymbols = new List<SObject>(); try { string commandString; switch (Mode) { case 0: // strict commandString = "SELECT IR FROM " + OracleDB + ".SIMBS WHERE EN LIKE '" + SymbolNamePart + "' "; break; case 1: // starting with commandString = "SELECT IR FROM " + OracleDB + ".SIMBS WHERE EN LIKE '" + SymbolNamePart + "%' "; break; case 2: // containing commandString = "SELECT IR FROM " + OracleDB + ".SIMBS WHERE EN LIKE '%" + SymbolNamePart + "%' "; break; case 3: // ending with commandString = "SELECT IR FROM " + OracleDB + ".SIMBS WHERE EN LIKE '%" + SymbolNamePart + "' "; break; default: commandString = "SELECT IR FROM " + OracleDB + ".SIMBS WHERE EN LIKE '" + SymbolNamePart + "' "; break; } //if (LimitOfResults != 0) { commandString += " Limit " + LimitOfResults + " "; } OracleCommand OracleCommand = new OracleCommand(commandString, OracleConnection); OracleDataReader myReader = OracleCommand.ExecuteReader(); ////if (OracleTrace) SQLView.Log(OracleCommand.CommandText); while (myReader.Read()) { if (!myReader.IsDBNull(0)) { SObject symbolID = new SObject(); //int.TryParse(myReader.GetString(0), out symbolID[0]); symbolID.ObjectId = (int)myReader.GetDecimal(0); if (symbolID.ObjectId != 0 || symbolID.ObjectId != 0) { ResultedSymbols.Add(symbolID); } } } myReader.Close(); } catch (OracleException retrieveSymbolIndexException) { Console.WriteLine("Error: {0}", retrieveSymbolIndexException.ToString()); } if (MyResultsTrace) { string ResultLog = ""; foreach (SObject i in ResultedSymbols) { ResultLog += " [" + i.ObjectId + ":" + "0" + "]"; } //SQLView.LogResult(new string[] { ResultLog }); } if (ResultedSymbols.Count < 1 && Mode == 0 && AcceptSymbols) { List<SObject> CreatedSymbols = new List<SObject>(); //CreatedSymbols = CreateSymbolByName(SymbolNamePart, true); ResultedSymbols = CreatedSymbols; } // Name symbols foreach (SObject symbol in ResultedSymbols) { symbol.ObjectName = GetSymbolNamesByID(symbol.ObjectId); } #region LOG //=== CUSTOM LOGGER=================================================================================== ObjectModel.CodeExplorer.CodeElementMethod thisMethod = new ObjectModel.CodeExplorer.CodeElementMethod(); int logLevel = logingOptions.levelNumbers; if (logLevel >= 3) // code { System.Diagnostics.StackTrace stackTrace; System.Diagnostics.StackFrame fr; stackTrace = new System.Diagnostics.StackTrace(); fr = stackTrace.GetFrame(0); thisMethod.ElementNamespaceName = this.GetType().Namespace; thisMethod.ElementClassName = this.GetType().Name; thisMethod.ElementName = stackTrace.GetFrame(0).GetMethod().ToString().Replace(stackTrace.GetFrame(0).GetMethod().Name.ToString(), "<span style='color: red'>" + stackTrace.GetFrame(0).GetMethod().Name.ToString()+"</span>"); } if (logLevel >= 2) // parameters { thisMethod.Parameters.Add(new string[] { "SymbolNamePart", SymbolNamePart.ToString() }); thisMethod.Parameters.Add(new string[] { "Mode", Mode.ToString() }); thisMethod.Parameters.Add(new string[] { "LimitOfResults", LimitOfResults.ToString() }); } if (logLevel >= 1) // results { string result = string.Empty; foreach (SObject id in ResultedSymbols) { result += "[" + id.ToString() + "]"; } thisMethod.Result = result; } //LoggingSystem.LoggingSystem.LogMethod = thisMethod; //==================================================================================================== #endregion LOG return ResultedSymbols; }
//public List<string> GetSymbolNamesByID(int[] SymbolID, int Mode = 0, int LimitOfResults = 10); //GetSymbolNamesByID = ServerAccessInterface.GetSymbolNamesByID; #endregion Adapter #region Interface Helpers #region create symbol table /// <summary> /// Create a nonexistent table and rezerve first line with id 1 /// </summary> /// <param name="symbolPosition">position of table reference in simbols table can be used to decode the table name</param> private void CreateSymbolTable(SObject symbolPosition) { //=== CUSTOM LOGGER=================================================================================== //if (LoggingSystem.LoggingSystem.TraceCode) { System.Diagnostics.StackTrace stackTrace; System.Diagnostics.StackFrame fr; string myLog; System.IO.StreamWriter log; stackTrace = new System.Diagnostics.StackTrace(); fr = stackTrace.GetFrame(0); //LoggingSystem.LoggingSystem.LogMessage = "<div> " + this.GetType().Namespace + " <span style='color:green'> " + this.GetType().Name + " </span>> " + stackTrace.GetFrame(0).GetMethod().ToString().Replace(stackTrace.GetFrame(0).GetMethod().Name, "<span style='color:blue'>" + stackTrace.GetFrame(0).GetMethod().Name + "</span>") + "</div>"; } //==================================================================================================== string commandString = " CREATE TABLE \"" + OracleDB + "\".\"S" + symbolPosition.ObjectId.ToString("00000000") + "\" ( \"ID\" NUMBER, \"A\" NUMBER, \"B\" NUMBER, \"C\" NUMBER, \"D\" NUMBER, \"E\" NUMBER, \"F\" NUMBER, \"G\" NUMBER, \"H\" NUMBER ) "; OracleCommand OracleCommand = new OracleCommand(commandString, OracleConnection); OracleCommand.ExecuteNonQuery(); commandString = " CREATE SEQUENCE \"" + OracleDB + "\".\"S" + symbolPosition.ObjectId.ToString("00000000") + "_SEQ_ID\" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 161 CACHE 20 NOORDER NOCYCLE "; OracleCommand OracleCommandSEQ = new OracleCommand(commandString, OracleConnection); OracleCommandSEQ.ExecuteNonQuery(); commandString = " create or replace TRIGGER S" + symbolPosition.ObjectId.ToString("00000000") + "_AUTOINCREMENT "; commandString += " BEFORE INSERT ON S" + symbolPosition.ObjectId.ToString("00000000") + " "; commandString += " REFERENCING OLD AS OLD NEW AS NEW "; commandString += " FOR EACH ROW "; commandString += " WHEN (NEW.ID IS NULL) "; commandString += " BEGIN "; commandString += " select S" + symbolPosition.ObjectId.ToString("00000000") + "_SEQ_ID.NEXTVAL "; commandString += " INTO :NEW.ID FROM dual; "; commandString += " END ; "; OracleCommand OracleCommandTRG = new OracleCommand(commandString, OracleConnection); OracleCommandTRG.ExecuteNonQuery(); //if (OracleTrace) SQLView.Log(OracleCommand.CommandText); commandString = "INSERT INTO \"" + OracleDB + "\".\"S" + symbolPosition.ObjectId.ToString("00000000") + "\" (\"A\", \"B\", \"C\", \"D\", \"E\", \"F\", \"G\", \"H\") VALUES (0,0,0,0,0,0,0,0) "; OracleCommand = new OracleCommand(commandString, OracleConnection); OracleCommand.ExecuteNonQuery(); //if (OracleTrace) SQLView.Log(OracleCommand.CommandText); }
// +GetSymbolsByName(SymbolsNamePart : string = "", Method : int = 0, LimitOfResults : int = 10, ResultedSymbols : List<int[2]>) public List<SObject> GetSymbolsByName(string SymbolNamePart, int Mode, int LimitOfResults = 10) { List<SObject> ResultedSymbols = new List<SObject>(); try { string commandString; switch (Mode) { case 0: // strict commandString = "SELECT \"IR\" FROM \"SIMBS\" WHERE \"EN\" LIKE '" + SymbolNamePart + "' "; break; case 1: // starting with commandString = "SELECT \"IR\" FROM \"SIMBS\" WHERE \"EN\" LIKE '" + SymbolNamePart + "%' "; break; case 2: // containing commandString = "SELECT \"IR\" FROM \"SIMBS\" WHERE \"EN\" LIKE '%" + SymbolNamePart + "%' "; break; case 3: // ending with commandString = "SELECT \"IR\" FROM \"SIMBS\" WHERE \"EN\" LIKE '%" + SymbolNamePart + "' "; break; default: commandString = "SELECT \"IR\" FROM \"SIMBS\" WHERE \"EN\" LIKE '" + SymbolNamePart + "' "; break; } //if (LimitOfResults != 0) { commandString += " Limit " + LimitOfResults + " "; } NpgsqlCommand OracleCommand = new NpgsqlCommand(commandString, NpgsqlConnection); NpgsqlDataReader myReader = OracleCommand.ExecuteReader(); //if (OracleTrace) SQLView.Log(OracleCommand.CommandText); while (myReader.Read()) { if (!myReader.IsDBNull(0)) { SObject symbolID = new SObject(); //int.TryParse(myReader.GetString(0), out symbolID[0]); symbolID.ObjectId = (int)myReader.GetDecimal(0); if (symbolID.ObjectId != 0 || symbolID.ObjectId != 0) { ResultedSymbols.Add(symbolID); } } } myReader.Close(); } catch (NpgsqlException retrieveSymbolIndexException) { Console.WriteLine("Error: {0}", retrieveSymbolIndexException.ToString()); } if (MyResultsTrace) { string ResultLog = ""; foreach (SObject i in ResultedSymbols) { ResultLog += " [" + i.ObjectId + ":" + "0" + "]"; } //SQLView.LogResult(new string[] { ResultLog }); } if (ResultedSymbols.Count < 1 && Mode == 0 && AcceptSymbols) { List<SObject> CreatedSymbols = new List<SObject>(); CreatedSymbols = CreateSymbolByName(SymbolNamePart, true); return CreatedSymbols; } return ResultedSymbols; }
//public List<string> GetSymbolNamesByID(int[] SymbolID, int Mode = 0, int LimitOfResults = 10); //GetSymbolNamesByID = ServerAccessInterface.GetSymbolNamesByID; #endregion Adapter #region Interface Helpers #region create symbol table /// <summary> /// Create a nonexistent table and rezerve first line with id 1 /// </summary> /// <param name="symbolPosition">position of table reference in simbols table can be used to decode the table name</param> private void CreateSymbolTable(SObject symbolPosition) { string commandString = "CREATE TABLE IF NOT EXISTS `" + DB + "`.`s" + symbolPosition.ObjectId.ToString("00000000") + "` ( `ID` INT , `a` INT NULL , `b` INT NULL , `c` INT NULL , `d` INT NULL , `e` INT NULL , `f` INT NULL , `g` INT NULL , `h` INT NULL , PRIMARY KEY (`ID`) );"; SQLiteCommand SqLiteCommand = new SQLiteCommand(commandString, SqLiteConnection); SqLiteCommand.ExecuteNonQuery(); //if (SqLiteTrace) SQLView.Log(SqLiteCommand.CommandText); commandString = "INSERT INTO `" + DB + "`.`s" + symbolPosition.ObjectId.ToString("00000000") + "` (`a`, `b`, `c`, `d`, `e`, `f`, `g`, `h`) VALUES (0,0,0,0,0,0,0,0) ;"; SqLiteCommand = new SQLiteCommand(commandString, SqLiteConnection); SqLiteCommand.ExecuteNonQuery(); //if (SqLiteTrace) SQLView.Log(SqLiteCommand.CommandText); }