none
Query '' is corrupt RRS feed

  • Question

  • An error("Query '' is corrupt") occur from following code.

    using (OleDbConnection conn_CDMR = new OleDbConnection(ConnectionString_CDMR)) { queryString = "UPDATE user_option " + "SET ansnumber = " + settingvalues.RepeatPerDay.ToString() + " WHERE option_name = 'RepeatPerDay'"; conn_CDMR.Open(); command = new OleDbCommand(queryString, conn_CDMR); command.ExecuteNonQuery(); <==== Error occur conn_CDMR.Close();

    }

    Error occur at command.ExecuteNonQuery();

    If I display queryString, it is like following. have no problem.

    "UDATE user_option SET ansnumber = 1 WHERE option_name = 'RepeatPerDay'"
    The error is like following.
    System.Data.OleDb.OleDbException (0x80004005): Query '' is corrupt.
       at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
       at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
       at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
       at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
       at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
       at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
       at Denttio.Message.CDMrCommon.SaveSettingValues() in C:\WorkDir\DenttioMessageApplication\CDMrCore\CDMrCommon.cs:line 4748
       at Denttio.Message.SettingsForm.bttnSave_Click(Object sender, EventArgs e) in C:\WorkDir\DenttioMessageApplication\CDMMsgView\SettingsForm.cs:line 111
       at System.Windows.Forms.Control.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
       at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)

    Can anybody give me some advice?


    • Edited by Jeff0803 Thursday, March 12, 2020 12:12 AM
    Thursday, March 12, 2020 12:09 AM

Answers