foreach (DataRow row in dssetparameter.Tables[0].Rows) { selectquery += " select '" + row["itemID"] +"'; as unit_param_id ,'" + row["paramvalue"] + '" as param_value,'" + row["date_logged"] +"' as date_logged ,'" + row["date_logged1"] + "' as OPCdate_logged,'" + row["Quality"] + "' as param_quality Union ALL" + Environment.NewLine; } if (selectquery != "") { selectquery = selectquery.Remove(selectquery.LastIndexOf("Union")); insertquery += " insert into " + tablename + " " + Environment.NewLine; insertquery += " (unit_param_id,param_value,date_logged,OPCdate_logged,param_quality)" + Environment.NewLine; insertquery += " " + selectquery + " "; if (con2.State == ConnectionState.Closed) con2.Open(); cmd2 = new OdbcCommand(insertquery, con2); cmd2.CommandTimeout = 500; cmd2.ExecuteNonQuery(); if (con2.State == ConnectionState.Open) con2.Close(); }
ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-6.0.11-alpha-community]memory exhausted near ''5332' as unit_param_id ,'' as param_value,'' as date_logged ,'' as OPCdate_logg' at line 5334
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)