Member Avatar for ignnniter

Im always getting Invalid Column, check the database and it's all correct.

     Dim borrowed As String = "Yes"
        dataopen()
        comm.Connection = conn
        comm.CommandText = "UPDATE Equipment SET Borrowed = '" & borrowed & "' WHERE EQID = '" & eid & "'"
        comm.ExecuteNonQueryAsync()
        comm.Dispose()
        conn.Close()
  • 4 Contributors
  • 3 Replies
  • 122 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by cxzei
Member Avatar for ryanjayson

What's the error? What is the datatype of Borrowed Fields? a bit or String? Try to remove the single quote from the query, on the Borrowed value

  Dim borrowed As String = "Yes"
        dataopen()
        comm.Connection = conn
        comm.CommandText = "UPDATE Equipment SET Borrowed = " & borrowed & " WHERE EQID = '" & eid & "'"
        comm.ExecuteNonQueryAsync()
        comm.Dispose()
        conn.Close()
Member Avatar for cxzei

put the value borrowed in single quotes...

UPDATE Equipment SET Borrowed = '" & borrowed & "' WHERE EQID = '" & eid & "'"
Edited by Reverend Jim because: fixed code formatting
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.