Skip to Content
0
Former Member
Nov 19, 2012 at 03:25 PM

Data Table - exceeds column data size [66000-148]

480 Views

Hi

I have written this in FormDataEvent . On this line it is giving error

Data Table - exceeds column data size [66000-148]

Dim oForm As SAPbouiCOM.Form = Me.SBO_Application.Forms.Item(BusinessObjectInfo.FormUID)

oForm.DataSources.DataTables.Item(0).ExecuteQuery("SELECT a.Code, a.Name,'' as Amount from [@TEMP]a")

Dim oGrid As SAPbouiCOM.Grid = oForm.Items.Item("MyGrid").Specific

Dim oDT As SAPbouiCOM.DataTable = oGrid.DataTable

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

RecSet.DoQuery("SELECT U_Code , U_Amount from [@TEMP1] where U_ID = '" & oForm.Items.Item("33").Specific.value.ToString.Trim & "'")

Dim i As Integer

For i = 0 To oDT.Rows.Count - 1

While RecSet.EoF = False

If oDT.GetValue("Code", i) = RecSet.Fields.Item(0).Value Then

oDT.SetValue("Amount", i, RecSet.Fields.Item(1).Value)

End If

RecSet.MoveNext()

End While

Next

Thanks