cancel
Showing results for 
Search instead for 
Did you mean: 

Choose from list in matrix

Former Member
0 Kudos

Hi,

I created choose from list in matrix.

How can i catch choose from list value in matrix.

Accepted Solutions (1)

Accepted Solutions (1)

ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

Try it like this:

if ((pVal.ItemUID == "Matrix") && (pVal.ColUID == "colItemCode") && pVal.EventType == BoEventTypes.et_CHOOSE_FROM_LIST && pVal.FormMode != 0)

{

                                        SAPbouiCOM.ChooseFromListEvent cflevent = (SAPbouiCOM.ChooseFromListEvent)pVal;

                                        SAPbouiCOM.ChooseFromList oCFLEvento = default(SAPbouiCOM.ChooseFromList);

                                        string strUid = cflevent.ChooseFromListUID;

                                        oCFLEvento = this.m_SBO_Form.ChooseFromLists.Item(strUid);

                                        SAPbouiCOM.DataTable oDataTable = cflevent.SelectedObjects;

                                        SAPbobsCOM.Recordset oRecSet = (SAPbobsCOM.Recordset)SBO_Company.GetBusinessObject(BoObjectTypes.BoRecordset);

                                        if (oDataTable == null)

                                        {

                                            m_SBO_Form.Freeze(false);

                                            return;

                                        }

                                        SAPbouiCOM.EditText oEdit = default(SAPbouiCOM.EditText);

                                        SAPbouiCOM.Matrix oMatrixItem = (SAPbouiCOM.Matrix)this.m_SBO_Form.Items.Item(pVal.ItemUID).Specific;

                                        int i = 0;

                                        int Row = pVal.Row;

for (i = 0; i <= oDataTable.Rows.Count - 1; i++)

                                        {

                                            string ItemCode = oDataTable.GetValue("ItemCode", i).ToString();

                                            try

                                            {

                                               

                                                oEdit = (SAPbouiCOM.EditText)oMatrixItem.Columns.Item("colItemCode").Cells.Item(Row).Specific;

                                                oEdit.Value = oDataTable.GetValue("ItemCode", i).ToString();

                                            }

catch { }

}

Hope it helps.

Kind regards,

ANKIT CHAUHAN

SAP Business One Global Support

Former Member
0 Kudos

I used this code.

My problem solved.

oDBs_Child = oForm.DataSources.DBDataSources.Item("@AIT_SCHEMAS_C")

                    oDBs_Child.SetValue("U_FreeItem", oDBs_Child.Offset, oDT.GetValue("ItemCode", 0))

                    oMatrix.SetLineData(pVal.Row)

Former Member
0 Kudos

Thank you for ur replay.

ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

Yes, It is also the another way to do it.

Please close this thread.

Kind regards,

ANKIT CHAUHAN

SAP Business One Global Support

Former Member
0 Kudos

Hi,

Thank you for your replay.

How to close this thread.

ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

Please click on the 'Correct Answer' or 'Assume Answered'.

Kind regards,

ANKIT CHAUHAN

SAP Business One Global Support

Answers (0)