# Bulk update TDAMemDataTable
**URL:** https://talk.remobjects.com/t/bulk-update-tdamemdatatable/27650
**Category:** Data Abstract
**Tags:** delphi
**Created:** [December 18, 2022, 7:19am UTC](https://talk.remobjects.com/t/bulk-update-tdamemdatatable/27650 "2022-12-18T07:19:17Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@TIMOTHY\_LAM](https://talk.remobjects.com/u/TIMOTHY_LAM)
#### Post date: [December 18, 2022, 7:19am UTC](https://talk.remobjects.com/t/bulk-update-tdamemdatatable/27650/1 "2022-12-18T07:19:17Z")
Hi,
I need to have bulk update the data in TDAMemDataTable. For example, I want to update 3 dimensions information for range of carton boxes (from Carton# 10 to Carton# 100) under over 4000 carton boxes. How can I do? I can’t using update command to update those records because it is under edit stage without click “Save” button.
---
### Author:  [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [December 18, 2022, 6:41pm UTC](https://talk.remobjects.com/t/bulk-update-tdamemdatatable/27650/2 "2022-12-18T18:41:41Z")
Hi,
What do you mean under `Save` button?
you can perform update data via cloned tables if main table in `Edit` state…
---
### Author:  [@TIMOTHY\_LAM](https://talk.remobjects.com/u/TIMOTHY_LAM)
#### Post date: [December 19, 2022, 1:16am UTC](https://talk.remobjects.com/t/bulk-update-tdamemdatatable/27650/3 "2022-12-19T01:16:04Z")
Hi,
User edits carton box dimension records that using the range carton numbers. How to update the information by bulk update? Suppose the records should keeping in cache mode until user click “Save” button to “ApplyUpdates”.
---
### Author:  [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [December 19, 2022, 10:03am UTC](https://talk.remobjects.com/t/bulk-update-tdamemdatatable/27650/4 "2022-12-19T10:03:00Z")
Hi,
ApplyUpdates means that changes will be send to server.
so you have changes on client-side only.
you can update data manually in memdatatable with
```delphi
for i:=0 to 4000-1 do begin
table.edit;
...
table.post;
end;
```
---
### Author:  [@TIMOTHY\_LAM](https://talk.remobjects.com/u/TIMOTHY_LAM)
#### Post date: [December 19, 2022, 11:38am UTC](https://talk.remobjects.com/t/bulk-update-tdamemdatatable/27650/5 "2022-12-19T11:38:30Z")
Hi,
I don’t want to use “for…loop”. The efficiency is not good. Because it has over 10K carton boxes per customer order.
---
### Author:  [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [December 19, 2022, 11:44am UTC](https://talk.remobjects.com/t/bulk-update-tdamemdatatable/27650/6 "2022-12-19T11:44:01Z")
Hi,
on client-side you can do it only via loop
on server-side you can do it via SQL like `UPDATE ...`
---
### Author:  [@TIMOTHY\_LAM](https://talk.remobjects.com/u/TIMOTHY_LAM)
#### Post date: [December 19, 2022, 1:54pm UTC](https://talk.remobjects.com/t/bulk-update-tdamemdatatable/27650/7 "2022-12-19T13:54:42Z")
Noted with thanks.
Would you consider to implement new feature that support client-side SQL update in future? Then it should help many guys to improve the data handling in client-side.
---
### Author:  [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [December 19, 2022, 3:38pm UTC](https://talk.remobjects.com/t/bulk-update-tdamemdatatable/27650/8 "2022-12-19T15:38:11Z")
Hi,
> [@TIMOTHY\_LAM](#):
>
> Would you consider to implement new feature that support client-side SQL update in future? Then it should help many guys to improve the data handling in client-side.
Looks like I misread you.
Check [TDARemoteCommand](https://docs.dataabstract.com/API/Delphi/Classes/TDARemoteCommand/) .