[Gambas-devel] Inability to change table data within Datamanager 1.9.20

[nigel at ...2...]

Benoit,

I've just noticed that data cannot be changed for the latest development version of the database manager. When comparing to the stable release 1.0.11 (which does work), I note that the function WriteData in FData.class is slightly different. When reapplying the differences, the change of data works;

e.g.

 WITH tbvData

    Connection.Handle.Begin

    $rData.MoveFirst

    FOR EACH $rData =========================> Remove this line!
    FOR iInd = 0 TO $rData.Count - 1 =================>Add This line

      IF $cDelete.Exist(iInd) THEN
        $rData.Delete
      ELSE IF $cData.Exist(iInd) THEN
        FOR EACH vVal IN $cData[iInd]
          sField = $cData[iInd].Key
          IF IsObject(Vval) THEN
            $rData[sField] = NULL
          ELSE
            $rData[sField] = vVal
          ENDIF
        NEXT
        $rData.Update
      ENDIF

      $rData.MoveNext ===========================> Add this line

    NEXT

regards

Nigel