Hi Everyone, I have to update some columns for multiple IDs in database. Ca

anilkumark over 8 years ago

Hi Everyone,
I have to update some columns for multiple IDs in database. Can any one suggest me how to update and which node is better to use "Write to Data Store Entity" or "Query Database" or "Stored Procedure" node?
Thanks in advance.

Discussion posts and replies are publicly visible

Parents

0 anilkumark over 8 years ago

I made my CDT as multiple but its not meeting my functionality. I am passing name: JOHN and number: 1234 for m_id: 23;24. But the name and number is updating only for first m_id. I want to update the multiple IDs at a time with the given name and number. mul_sampleTable(variable) of Type: SampleTable (CDT) = [m_id=23, name=JOHN, number=1234, archive=0, pid=268439932], [m_id=24, name=, number=, archive=, pid=].

Something I am missing, can any one help me how to update the data for multiple IDs.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 anilkumark over 8 years ago

I made my CDT as multiple but its not meeting my functionality. I am passing name: JOHN and number: 1234 for m_id: 23;24. But the name and number is updating only for first m_id. I want to update the multiple IDs at a time with the given name and number. mul_sampleTable(variable) of Type: SampleTable (CDT) = [m_id=23, name=JOHN, number=1234, archive=0, pid=268439932], [m_id=24, name=, number=, archive=, pid=].

Something I am missing, can any one help me how to update the data for multiple IDs.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data