How can I save createddatetime value to another table with Insert_recordset ?

Finance and Operations/AX Developer Forum
1

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?

}

2

Could you please tell us what error do you get?

3

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

4

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 "