web

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

News and Announcements icon

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)

Suggested answer

dolee 11,279 on at

Like (1)

Report

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
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,953 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans