web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) how to use method insi...

Microsoft Dynamics AX (Archived)

how to use method inside insert_recordset

(0) Share

Report

Report

Posted on by ahmed.kimo

546

Hi,

i have example like bellow :

insert_recordset TmpTable (ID,Name,CurrentUserId)

select ID,Name, curUserId()

from SourceTable;

how i can use curUserId() in this statement just i need to take current user id in all records which is inserted into the temp table ,

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

You could get answers for majority of your questions using the MSDN documentation and various blogs, please rely on search engines more in the future.

See example 3 for insert_recordset operation in the documentation:

msdn.microsoft.com/.../aa635694.aspx

You could assign it to a variable first.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

You are using it all wrong.

If you want to extract user id from any table then acquire that field in "userId" EDT.

In your case, it looks like that you want to store the current user id in your table named TmpTable. In order to use curUserId(), you need to store it into some variable and then insert it.

"insert_recordset" is a good way for bulk insertion but has a limitation that you cannot manipulate your data while insertion which in your case is necessary.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 39

#2

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans