ZeosLib update
lazarus / 16-Databases

----------------------------------------------------------------------
anis2505 · 2016-04-28 08:13

Hi all,

When I'm updating multiple records. only the first one is affected but
the others remains unchanged.

i'm updating them one by one

Quotewith ZQNote do
  begin
        Edit;

        FieldByName('F1').AsInteger := F1;
        FieldByName('F2').AsFloat := F2;

        Post;
        ApplyUpdates;
  end;


Any Ideo what's wrong in here

regards

----------------------------------------------------------------------
Mando · 2016-04-28 10:17

Hello:

Your code only updates the active record of ZQNote.

if you want  to update all the records in ZQNote, you must do a loop,
like this:

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i with ZQNote
do  begin      first;      while not eof do      begin        Edit;  
     FieldByName('F1').AsInteger := F1;       
FieldByName('F2').AsFloat := F2;         Post;        next;     end;  
    ApplyUpdates;  end; 

regards.

----------------------------------------------------------------------
anis2505 · 2016-04-28 12:47

Hi 

The problem isn't on looping or so.

The problem is when I update the first the second and so on, only the
first one gets changed which is odd

regards

----------------------------------------------------------------------
Mando · 2016-04-28 15:51

Hi.

It must due to TransactIsolationLevel  property  of TConnection, 
CachedUpdates property of TZQuery (ZQNote) and

Use tiReadCommitted for TransactIsolationLevel
and false to CachedUpdates.






Regards.