Problem in manipulation the database
Is it possible to manipulate the database table dierectly using the recordset object or SQL Query.
Thanks & Regards
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.