Skip to Content
0
Sep 14, 2018 at 06:25 PM

DI API Wrong way to perform update?

113 Views

This is Probably an easy question for the experienced but that is not me.

Lets say I have a user defined field in oitm

Am I not supposed to do an update as such?

        Dim myRs As SAPbobsCOM.Recordset = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

        Dim sQuery As String = "update oitm set myColumn = 'mynewvalue'where keyColumn = 'uniquevalue'" 
myRs.DoQuery(sQuery) 'update performed

Is this operation ok?

Am I risking my databases integrity?