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;