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

  1. 2 weeks ago
  2. Dave S

    Feb 12 San Diego, California USA

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

  3. Jean-Yves P

    Feb 12 Pre-Release Testers, Xojo Pro Europe (France, Besancon)

    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!