Member Avatar for MaryRose_1

i am using this code in updating multiple data in listview but it doesn't work, what code should i replace to run this command save

    dbConn
        sample RS.Open "Select * from table where field = '" & listview.listitem & "'", , conn, adOpenKeyset, adLockOptimistic
                If RS.RecordCount = "0" Then
  • 2 Contributors
  • 1 Reply
  • 167 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by Nutster
Member Avatar for Nutster

A SELECT statement only reads information; it does not update anything. There is a lot of code missing around this that is needed to actually do anything useful. Please post more complete code (that will actually compile) or post the error message when you try to compile.

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.