Devart Forums

(delphi 2006)
I want to update multiple records (e.g. 10000 rows) , each of which has different values.

In the ODAC for Oracle it is possible like that:
{
OraSql : TOraSql;

OraSQL.sql.text := 'update Roads set E1 = :p1 where ID = :p2';
OraSQL.prepare;

OraSQL.Params.items[1].Itemasinteger[counter] := IntArray[0];
OraSQL.Params.items[0].ItemasFloat[counter] := DataArray[0];

inc(counter);
if counter > 10000 then OraSQL.exeute(10000);
}

Is there a component in MyDAC that I can have the same function?

In ODAC this possibility is supported by Oracle server. MySQL does not support such functionality. Therefore in MyDAC you should use cycle to update multiple records.

thank you