web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

convert datatype in insert_recordset method

(0) ShareShare
ReportReport
Posted on by 570

 Hi all,

Using  insert_recordset method insert the record from one table to other name.

Fields are same but datatype is different .I use below code but show error in conversation.

Bu is int data type in jmTrialTestTBCopy,

BU is Str data type in jmTrialTestTB,

 

 

JMTrialTestTB jmTrialTestTB;

JMTrialTestTBCopy jmTrialTestTBCopy;

insert_recordset jmTrialTestTBCopy

(Main,

BU,

LE)

select Main,BU,LE from jmTrialTestTB;

I have the same question (0)
  • Suggested answer
    Martin Dráb Profile Picture
    236,879 Most Valuable Professional on at
    RE: convert datatype in insert_recordset method

    It seems that you again has a bug in the data model.

    As discussed in your other thread, the best approach would be fixing your data model. If it's truly impossible for you, a possible workaround is creating a view with the computed column, where you'll do the conversion. Then you can query this view instead of JMTrialTestTB.

  • TonyAx Profile Picture
    570 on at
    RE: convert datatype in insert_recordset method

    Thanks for replay Martin,

    Sure I will approach in view

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 683 Super User 2025 Season 2

#2
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 620

#3
Martin Dráb Profile Picture

Martin Dráb 563 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans