# How can I save createddatetime value  to another table with Insert\_recordset ?

**URL:** https://www.dynamicsuser.net/t/how-can-i-save-createddatetime-value-to-another-table-with-insert-recordset/61346
**Category:** Developer Forum
**Created:** [August 17, 2016, 11:28am UTC](https://www.dynamicsuser.net/t/how-can-i-save-createddatetime-value-to-another-table-with-insert-recordset/61346 "2016-08-17T11:28:17Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Recep](https://avatars.discourse-cdn.com/v4/letter/r/45deac/32.png) [@Recep](https://www.dynamicsuser.net/u/Recep)
#### Post date: [August 17, 2016, 11:28am UTC](https://www.dynamicsuser.net/t/how-can-i-save-createddatetime-value-to-another-table-with-insert-recordset/61346/1 "2016-08-17T11:28:17Z")

</div>

Hello,

There ara 2 tables. Table1 and Table2.

The following code gives an error .

Insert\_recordset Table2 (field1\_utcdatetime)

Select createdDateTime From Table1;

But this code is not error;

While Select createdDateTime From Table1

{

Table2.clear();

Table2.field1\_utcdatetime = Table1.createdDateTime;

Table2.insert();

}

…

How to save it with insert\_recordset method?

}

---

<div class="post-metadata">

### Author: ![MartinDrab](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@MartinDrab](https://www.dynamicsuser.net/u/MartinDrab)
#### Post date: [August 18, 2016, 6:26am UTC](https://www.dynamicsuser.net/t/how-can-i-save-createddatetime-value-to-another-table-with-insert-recordset/61346/2 "2016-08-18T06:26:30Z")

</div>

Could you please tell us what error do you get?

---

<div class="post-metadata">

### Author: ![Recep](https://avatars.discourse-cdn.com/v4/letter/r/45deac/32.png) [@Recep](https://www.dynamicsuser.net/u/Recep)
#### Post date: [August 18, 2016, 7:06am UTC](https://www.dynamicsuser.net/t/how-can-i-save-createddatetime-value-to-another-table-with-insert-recordset/61346/3 "2016-08-18T07:06:27Z")

</div>

“The Application Object Server is unavailable. Check your configuration an network connection and try again” …!!!

---

<div class="post-metadata">

### Author: ![Recep](https://avatars.discourse-cdn.com/v4/letter/r/45deac/32.png) [@Recep](https://www.dynamicsuser.net/u/Recep)
#### Post date: [August 18, 2016, 7:14am UTC](https://www.dynamicsuser.net/t/how-can-i-save-createddatetime-value-to-another-table-with-insert-recordset/61346/4 "2016-08-18T07:14:19Z")

</div>

ttsbegin;  
insert\_recordset tbTarget (Date1,TFielld1)  
Select createdDateTime,SField1 from tbSource Where tbSource.SField1 == “123”;  
ttscommit;  
Error is “The Application Object Server is unavailable. Check your configuration an network connection and try again”

But…

ttsbegin;  
insert\_recordset tbTarget (Date1)  
Select createdDateTime from tbSource Where tbSource.SField1 == “123”;  
ttscommit

Error is "TargetTable ( TargetTable ) can not be played on a data definition language command. SQL database gave an error "