Zeoslib Portal

Zquery1.SQL.Clear;
Zquery1.SQL.Add('update tbharga Set HARGA= :Harga where NamaRs="' + RS + '" && KODEPRODUK="' + KodeProduk + '"');
zquery1.ParamByName('Harga').AsInteger := Harga;
zquery1.ExecSQL;

I've tried above script, but still the process is very slow. Need advise

Hi jpnuage,

I've tried before using ZQuery, but I got error "Can not open a ResultSet"

Dear Master, Need help, I have table in mysql which has 978.828 records. When I try this script, the process is very slow (the application like hang up) zsqlprocessor1.Clear; zsqlprocessor1.Script.Text := 'update tbharga Set HARGA="' + inttostr(Harga) + '" where NamaRs="' + RS + '&quo...