Matrix

[Former Member]

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()

[Former Member]

Hello

This will not save the data. You basic idea is ok, but incomplete

After you loaded the data from Datatable, you must bind your matrix to the dbdatasources , then it will save the data.

Also you can program the saving by code.

Regards

János

[Former Member]

Hi

Try with this change in you code

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

Regards

Vivek