I have the following code:

        Dim updateConnection As OleDbConnection = GetConnection()
        Dim updateSQL As String = _
        "UPDATE Last_Incident_nbr " _
        & "Set Last_Incident_Nbr = @new_incident_Nbr," _
        & "Last_Incident_date = @newDate " _
        & "where last_incident_date = @last_Incident_date;"
        Dim updateCommand As New OleDbCommand(updateSQL, updateConnection)
        updateCommand.CommandText = CommandType.StoredProcedure
        updateCommand.Parameters.AddWithValue("@Last_Incid ent_Nbr", NewIncident)
        updateCommand.Parameters.AddWithValue("@Last_Incid ent_date", newDate)

        Try
            Dim intRowsaffected As Integer
            updateConnection.Open()
            intRowsaffected = updateCommand.ExecuteNonQuery()

            updateConnection.Close()
            MessageBox.Show(intRowsaffected, "Finished Update")
        Catch ex As Exception
            MessageBox.Show(ex.Message, ex.GetType.ToString)
        End Try

and I am getting the error message:

"INVALID SQL STATEMENT, EXPECTED "DELETE", "INSERT", "PROCEDURE", "SELECT" OR "UPDATE".

Can anyone tell me what I am doing wrong?


mfb

__________________
mfb

mmm.. and if you try to actually pass the sql to the command ;)???

is wrong, should be:
and that's why you were loosing your sql...


HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========

I made those changes to be the following but now I get a new error:

Dim updateConnection As OleDbConnection = GetConnection()
        Dim updateCommand As New OleDbCommand()
        updateCommand.Connection = updateConnection
        updateCommand.CommandType = CommandType.Text
        updateCommand.CommandText = _
         "UPDATE Last_Incident_nbr " _
        & "Set Last_Incident_Nbr = @new_incident_Nbr," _
        & "Last_Incident_date = @newDate " _
        & "where last_incident_date = @last_Incident_date;"
        updateCommand.Parameters.AddWithValue("@Last_Incid ent_Nbr", NewIncident)
        updateCommand.Parameters.AddWithValue("@Last_Incid ent_date", newDate)


The error is: "NO VALUE GIVEN FOR ONE OR MORE REQUIRED PARAMETERS"

mfb

well.. that's another problem.. the sql is wrong.. test it on the database and you will see.. probably you misspelled a field name or the table name... or you are sending to the sql few parameters (i see 3 on the sql, are you sending 3???)

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========

Ummm You are you using 3 parameters in your query, but only add 2 to your connection.

You use: @new_incident_Nbr, @newDate, and @last_incident_date

But you only declare @Last_incident_Nbr and @Last_Incident_date

Add another
updateCommand.Parameters.AddWithValue("@newdate", newDate)

to correct the problem.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========