RecordSet.Edit Will only Update the Table on the Second Attempt

  1. last year
  2. Dave S

    12 Feb 2018 San Diego, California USA

    posting the same question twice, won't provide any more or better answers

  3. Jean-Yves P

    12 Feb 2018 Pre-Release Testers, Xojo Pro Europe (France, Besançon)

    use an UPDATE...SET sql command instead of the SELECT and then recordset.edit method.
    it will be easier, faster if you have a lot of (remote) records, and works all the time even if the recordset does not contain the primary key.

or Sign Up to reply!