Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem in manipulation the database

Hi All,

Is it possible to manipulate the database table dierectly using the recordset object or SQL Query.

Thanks & Regards

Kirti

Former Member
Former Member replied

hi kirti,

It is prohibited to manipulate the database tables directly using the Recordset object or SQL statements (DML actions), because SAP Business One does not validate the updated tables and therefore forward compatibility is not guaranteed.

DML operations are acceptable with the Recordset object for user tables only. For other business objects use only the relevant DI objects and not the Recordset object.

Any DML operations on system tables pose a high risk for data corruption, and will not be supported. Use at your own risk.

regards

nirdesh panwar

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question