cancel
Showing results for 
Search instead for 
Did you mean: 

Update record through RecordSet Object on SAP B1

former_member711254
Discoverer
0 Kudos
286

Hi everyone, I would like to know if an update statement using the RecordSet business object is a bad practice?

A code line below, for instance:

oRecordSet.DoQuery("UPDATE OINV SET U_MyField = 'Test' WHERE DocEntry = 202020");

Best regards!

View Entire Topic
ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi j.martins_,

Indeed, it is a bad practice.

Kindly refer to the following blog post for the Guidelines for Modifying SAP Business One Data.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

former_member711254
Discoverer
0 Kudos

Thank you ankit.chauhan1! These guidelines are very useful! Bookmarked!

No questions left!