What is the maximume data size can SAPbobsCOM.GeneralData.SetProperty(string,Object) can store , I am getting an exception the size of data is too long, and what is the replacement to store longer data size on UDO table ?
Please check the following thread. This could help u.
U need to use the GeneralService object to access the UDO, the following sample is provided by SAP B1 help. I could not give more inputs regarding this as i have not worked on this object. Plz try that.
The GeneralService provides access to UDOs.
With the service, you can add, look up and remove rows from user-defined tables. You can also invoke custom methods on the UDO's custom business implementation DLL.
Dim oGeneralService As SAPbobsCOM.GeneralService
Dim oGeneralData As SAPbobsCOM.GeneralData
Dim oChild As SAPbobsCOM.GeneralData
Dim oChildren As SAPbobsCOM.GeneralDataCollection
Dim oGeneralParams As SAPbobsCOM.GeneralDataParams
'Get GeneralService (oCmpSrv is the CompanyService)
Set oGeneralService = oCmpSrv.GetGeneralService("MainUDO")
'Create data for new row in main UDO
Set oGeneralData = oGeneralService.GetDataInterface(gsGeneralData)
oGeneralData.SetProperty "Code", "First"
oGeneralData.SetProperty "U_Data", "my data"
'Create data for a row in the child table
Set oChildren = oGeneralData.Child("ChildUDO")
Set oChild = oChildren.Add
oChild.SetProperty "U_Data", "child data"
oChild.SetProperty "U_Type", 6
'Add the new row, including children, to database
oGeneralService.Add oGeneralData
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.