good day.!

whats wrong with this sql query.Im using mysql as backend 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.

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