# Retreive datatable schema command erases all clients events
**URL:** https://talk.remobjects.com/t/retreive-datatable-schema-command-erases-all-clients-events/20313
**Category:** Data Abstract
**Tags:** vcl
**Created:** [September 16, 2019, 7:58am UTC](https://talk.remobjects.com/t/retreive-datatable-schema-command-erases-all-clients-events/20313 "2019-09-16T07:58:15Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@infolyseis](https://talk.remobjects.com/u/infolyseis)
#### Post date: [September 16, 2019, 7:58am UTC](https://talk.remobjects.com/t/retreive-datatable-schema-command-erases-all-clients-events/20313/1 "2019-09-16T07:58:16Z")
in 10.0.0.1449, Retreive datatable schema command erases all fields events.
I double checked this behaviour by creating a new dataabstract vcl application with custom server and used the default pctrade schema. The i added on tbl\_customer.name a onChange event. If i retreive the schema, the event is cleared.
im using delphi 10.3 update 2.
---
### Author:  [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [September 16, 2019, 8:33am UTC](https://talk.remobjects.com/t/retreive-datatable-schema-command-erases-all-clients-events/20313/2 "2019-09-16T08:33:10Z")
Hi,
You have assigned event to the some field, is it correct?
if yes, this is as expected because retrieving of schema does:
- calls `Fields.Clear;`
- reads every field from stream
workaround: you should reassign field events after loading table schema
---
### Author:  [@infolyseis](https://talk.remobjects.com/u/infolyseis)
#### Post date: [September 16, 2019, 8:54am UTC](https://talk.remobjects.com/t/retreive-datatable-schema-command-erases-all-clients-events/20313/3 "2019-09-16T08:54:37Z")
Hello Evgeny,
my problem is that that happens in IDE when i right click on MemDataTable, a behavior that didn’t happen in the past. I know thata solution whould be to assign events on code.
Thanks for your reply.
---
### Author:  [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [September 16, 2019, 9:12am UTC](https://talk.remobjects.com/t/retreive-datatable-schema-command-erases-all-clients-events/20313/4 "2019-09-16T09:12:34Z")
Hi,
for client-calculated/located fields events will be preserved, but for usual fields, events will be lost always.
this behavior wasn’t changed for ages
---
### Author:  [@infolyseis](https://talk.remobjects.com/u/infolyseis)
#### Post date: [September 16, 2019, 10:00am UTC](https://talk.remobjects.com/t/retreive-datatable-schema-command-erases-all-clients-events/20313/5 "2019-09-16T10:00:31Z")
Hi,
i beg to differ. As you can see on this screencast on version 9- that was the default behavior
> **[OldVersion.mp4 (video)](https://drive.google.com/file/d/19fsSjSH2bl-nFlqqLauUopm_h4yO-wLf/view?usp=drive_open)**
>
> Google Drive file.
---
### Author:  [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [September 16, 2019, 11:02am UTC](https://talk.remobjects.com/t/retreive-datatable-schema-command-erases-all-clients-events/20313/6 "2019-09-16T11:02:50Z")
Hi,
I can reproduce this behavior with the latest DA9 and can’t with DA10.
also I can’t find what code causes it because `TDADataTable.LoadSchema` method wasn’t changed…
---
### Author:  [@DonaldShimoda](https://talk.remobjects.com/u/DonaldShimoda)
#### Post date: [September 17, 2019, 12:25pm UTC](https://talk.remobjects.com/t/retreive-datatable-schema-command-erases-all-clients-events/20313/7 "2019-09-17T12:25:11Z")
> [@EvgenyK](#):
>
> events will be lost always.
Can you declare field events using business client rules as with table events? If true then you can fix that way. If dont I believe have no sense (and is incorrect) loading schema at design time delete fields events, dont you believe?
---
### Author:  [@RemObjectsSoftware](https://talk.remobjects.com/u/RemObjectsSoftware)
#### Post date: [September 18, 2019, 2:58pm UTC](https://talk.remobjects.com/t/retreive-datatable-schema-command-erases-all-clients-events/20313/8 "2019-09-18T14:58:16Z")
Thanks, logged as [bugs://83273](https://www.remobjects.com/portal/bugs/?id=83273)
---
### Author:  [@EvgenyK](https://talk.remobjects.com/u/EvgenyK)
#### Post date: [September 18, 2019, 2:59pm UTC](https://talk.remobjects.com/t/retreive-datatable-schema-command-erases-all-clients-events/20313/9 "2019-09-18T14:59:02Z")
I’ve found a reason for such failure. will fix.
---
### Author:  [@RemObjectsSoftware](https://talk.remobjects.com/u/RemObjectsSoftware)
#### Post date: [September 23, 2019, 2:58pm UTC](https://talk.remobjects.com/t/retreive-datatable-schema-command-erases-all-clients-events/20313/10 "2019-09-23T14:58:35Z")
[bugs://83273](https://www.remobjects.com/portal/bugs/?id=83273) got closed with status fixed.