Update record through RecordSet Object on SAP B1

[former_member711254]

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!

[ANKIT_CHAUHAN · Accepted solution]

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 · Accepted solution]

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

No questions left!