**********************************************************  
 Time Of Error            : 11/30/2021 9:17:43 PM
 Error Message            : Fatal error encountered during command execution.
 Error Exeption            : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'RATE varchar(500) ,
MRP varchar(500) )#ITEMID,TESTCODE,DEPARTMENT,ITEMNAME,B2B R' at line 7
   at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
   at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
   at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   --- End of inner exception stack trace ---
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
 Error Place              :    at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Itdose\Probe Live\App_Code\DataLinkLayer\ODBCHelper.cs:line 324
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Itdose\Probe Live\App_Code\DataLinkLayer\ODBCHelper.cs:line 300
   at StockReports.ExecuteDML(String strQuery) in d:\Itdose\Probe Live\App_Code\BuisnessLogic\Finance\StockReports.cs:line 598
   at Design_EDP_ImportToDatabase.btnSave_Click(Object sender, EventArgs e) in d:\Itdose\Probe Live\Design\EDP\ImportToDatabase.aspx.cs:line 132
 Error On Machine         : DESKTOP-1P6SB3J
 Error Machine IP Address : 192.168.1.2


  **********************************************************  
 Time Of Error            : 11/30/2021 9:21:09 PM
 Error Message            : Fatal error encountered during command execution.
 Error Exeption            : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'RATE varchar(500) ,
MRP varchar(500) )#ITEMID,TESTCODE,DEPARTMENT,ITEMNAME,B2B R' at line 7
   at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
   at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
   at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   --- End of inner exception stack trace ---
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
 Error Place              :    at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Itdose\Probe Live\App_Code\DataLinkLayer\ODBCHelper.cs:line 324
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Itdose\Probe Live\App_Code\DataLinkLayer\ODBCHelper.cs:line 300
   at StockReports.ExecuteDML(String strQuery) in d:\Itdose\Probe Live\App_Code\BuisnessLogic\Finance\StockReports.cs:line 598
   at Design_EDP_ImportToDatabase.btnSave_Click(Object sender, EventArgs e) in d:\Itdose\Probe Live\Design\EDP\ImportToDatabase.aspx.cs:line 132
 Error On Machine         : DESKTOP-1P6SB3J
 Error Machine IP Address : 192.168.1.2