Problem in manipulation the database

[Former Member]

Hi All,

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

Thanks & Regards

Kirti

[Former Member · Accepted solution]

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

[Eneveux]

Kirti,

SAP does not allow for the Business One tables to be directly accessed via a SQL statement for manipulation. This is not allowed and SAP Support does not support this type of action. If you are looking to manipulate data in Business One, it is recommended that you use the SAP Business One SDK.

Eddy

[AdKerremans]

Hi Kirti,

If you mean inserting/deleting/modifiying records, it is possible, but you will problably loose support from SAP if you do this on SBO Tables.

On your own UDF tables, I don't think it is a problem.

Regards

Ad