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