Devart Forums

OraQuery How to .UpdateBatch like adoquery.UpdateBatch?

You should set the CachedUpdates property of TOraQuery to True, and call the ApplyUpdates method that is an analog of the TADOQuery.UpdateBatch method.

i set the oraquery.CachedUpdates:=true,but TOraQuery have not .UpdateBatch method,what is method i can use ?

i set the .CachedUpdates as true and LocalUpdate as true , and use the method of .ApplyUpdates. but it noticed that this poeration on an opendataset.
I can't find the method of UpdateBatch like TAdoQuery.

The LocalUpdate property must be False.

Both methods TADOQuery.UpdateBatch and TOraQuery.ApplyUpdates should be called on opened dataset. You should open the dataset, make some changes to data, then call the ApplyUpdates method.

//q:toraquery;

opensql:='select CODE,XM,DZ from A1 where CODE is NULL';
if q.Active then q.Close;
q:=openquery(opensql,psession);
self.DataSource1.DataSet:=q;
q.ReadOnly:=false;
q.LocalUpdate:=false;
for i :=1 to 100 do // Iterate
begin
q.AppendRecord([InttoStr(i),'XXXX,'111']);
end; // for
q.CachedUpdates:=true;
q.ApplyUpdates;

Is there someting wrong? It noticed that "can't modify a read-only dataset".

I set LocalUpdate property to be False, but can't not appendrecord.

I want to append record in batch in locally and finally append all the data to database.

I use dbgrid to list the data, dbgrid.readonly:=false.

I set LocalUpdate property to be False, but can't not appendrecord.
but I set LocalUpdate property to be True, it can appendrecord,but can't applyupdate.

Set CachedUpdates = True before opening the dataset.

If you are using ODAC version before 6.0, TOraQuery component is read-only unless you have set the SQLInsert property. You can you the TSmartQuery component instead of TOraQuery. TSmartQuery generates INSERT statement automatically.

thank you very much. I change ODAC version 6.7.. I succeeded.