Update individual row in datagrid
lazarus / 16-Databases

----------------------------------------------------------------------
pcurtis · 2021-01-21 11:38

Hi All,

I am using sqlite with zeos.

My question is "How can I show changes to a row in a DBGrid without
refreshing the whole dataset?"

Test app attached.

----------------------------------------------------------------------
paweld · 2021-01-21 19:45

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 procedure
TForm1.Button2Click(Sender: TObject);var  iTEMP : integer;begin  if
ZQuery1.IsEmpty then  exit;  iTEMP := Random(10);  ZQuery1.Edit; 
ZQuery1.FieldByName('fnCOUNT').AsInteger := iTEMP; 
ZQuery1.ApplyUpdates;  Button2.Caption := iTEMP.ToString;end;     
if you use only one table in query you can do it this way, but if you
use several tables (e.g. via JOIN) then you have to use the
ZUpadateSQL component