web

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

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) insert_recordset with ...

Microsoft Dynamics AX (Archived)

insert_recordset with constant value

(0) Share

Report

Report

Posted on by Community Member

Hello,

How can I use insert_recordset command in order to insert to table a column with 'constant' value.

something like:

insert_recordset mytable(mycol1, mycol2, mycol2)

select col1, col2, 'bbbb' from mytable2;

How can I insert 'bbbb' to the mycol3 in insert_recordset statement?

If not - what are the alternatives? (need fast way to insert).

Thanks :)

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

Martin Dráb 236,047 Most Valuable Professional on at

Like (0)

Report

RE: insert_recordset with constant value

Dominic's answer is correct. It's also clearly explained in documentation.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: insert_recordset with constant value

I guess the easiest way is defining constant values in a parameter table.

Was this reply helpful? Yes No
Suggested answer

dolee 11,279 on at

Like (1)

Report

RE: insert_recordset with constant value

Hi Eitan,

Try this:

String255 txt = "bbbb";

insert_recordset mytable(mycol1, mycol2, mycol2)

select col1, col2, txt from mytable2;

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Our Community Code of Conduct has been updated!

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 2 Most Valuable Professional

#1

Guy Terry 2 Moderator

#1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans