ADO and MySQL database problem

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Steven
    #1

    ADO and MySQL database problem

    I'm using VB6 and MySQL database server, I work fine for select statement
    and I can view the data but I can't "INSERT, UPDATE and DELETE" data at
    MySQL database.

    It return a error code "run-time error 3251, current recordset does not
    support updating. This may be a limitation of the provider, or of the
    selected locktype"

    Does anyone know how to INSERT, UPDATE and DELETE record at MySQL? If you
    have, please provide some CODE?

    Many thanks
    Tags: None
    • Adrian Parker
      #2
      Re: ADO and MySQL database problem


      "Steven" <steventong@sha nghailand.com> wrote in message
      news:395c623a.0 309260042.35e84 3c@posting.goog le.com...[color=blue]
      > I'm using VB6 and MySQL database server, I work fine for select statement
      > and I can view the data but I can't "INSERT, UPDATE and DELETE" data at
      > MySQL database.
      >
      > It return a error code "run-time error 3251, current recordset does not
      > support updating. This may be a limitation of the provider, or of the
      > selected locktype"
      >
      > Does anyone know how to INSERT, UPDATE and DELETE record at MySQL? If you
      > have, please provide some CODE?[/color]

      adoRecordSet.Ad dNew

      adoRecordSet.De lete

      Hmmm, update? adoREcordset.re query?


      Adrian


        Comment

        Previous template Next
        Working...