Skip to Content
0
Former Member
Aug 24, 2011 at 07:35 AM

Matrix

15 Views

Hi,

I have created auto managed form and in this form I am bind matrix using below code. after binding grid when i press on add button data is not saved in table. In table rows is inserted with null values.

oForm.DataSources.DataTables.Item("@STPODTL").ExecuteQuery("exec SP_CreatePO '" & oForm.Items.Item("txtFdate").Specific.value & "','" & oForm.Items.Item("txtTdate").Specific.value & "'")

Dim oColumns As SAPbouiCOM.Columns = oMatrix.Columns()

oColumns.Item("Matsel").DataBind.Bind("@STPODTL", "U_Sel")

oColumns.Item("matSono").DataBind.Bind("@STPODTL", "matSono")

oColumns.Item("matItemcd").DataBind.Bind("@STPODTL", "U_ItemCode")

oColumns.Item("matItemNm").DataBind.Bind("@STPODTL", "matItemNm")

oColumns.Item("matcolor").DataBind.Bind("@STPODTL", "matcolor")

oColumns.Item("matSize").DataBind.Bind("@STPODTL", "matSize")

oColumns.Item("matPurqty").DataBind.Bind("@STPODTL", "U_PurQty")

oColumns.Item("matAvl").DataBind.Bind("@STPODTL", "U_AvalQty")

oColumns.Item("matTqty").DataBind.Bind("@STPODTL", "U_TotalQty")

oColumns.Item("matRQty").DataBind.Bind("@STPODTL", "U_Rqty")

oColumns.Item("matsel").DataBind.Bind("@STPODTL", "U_Force")

oMatrix.LoadFromDataSource()