Member Avatar for PinoyDev

good day.!

whats wrong with this sql query.Im using mysql as backend database.it hangs when i execute this sql code:

Dim statusko, oldstatus As String

statusko = "verified"
oldstatus = "to be verified"

sql3 = "UPDATE paymentsummary SET status='" & statusko & "' Where username='" & ListView1.ListItems.Item(listselect).SubItems(4) & "' and status='" & oldstatus & "'"
         rs3.Open sql3, conn, adOpenKeyset, adLockOptimistic

Pls help.

God bless on this mother earth.

  • 2 Contributors
  • 1 Reply
  • 81 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by vb5prgrmr
Member Avatar for vb5prgrmr

Well you are using a recordset object which is normally for retrieving records. Check either you connection object or you database object (if you have one) for the .execute method. i.e.

conn.execute sql3
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.