How to get the Selected column no. of matrix

[Former Member]

Hi Expert,

How to get the selected column of the matrix.

I am trying to make validation on specific column of matrix.so i wanted to get the column id of the selected matrix column.

Dhanraj Kotian

[Former Member · Accepted solution]

Dear Dhanraj Kotian,

You can get the column id by pVal.ColUID in the ItemEvent as following:

Private Sub SBO_Application_ItemEvent(ByVal FormUID As String, pVal As SAPbouiCOM.IItemEvent, BubbleEvent As Boolean)

........
    If pVal.FormType <> 0 Then

        Select Case pVal.EventType
 
         Case et_LOST_FOCUS:
           oColid =   pVal.ColUID
........

Best Regards

Jane Jing

SAP Business One Forums team

[Former Member]

Dear Dhanraj Kotian,

You could catch the event like et_ITEM_PRESSED or et_LOST_FOCUS, then check if the specific column is Selected, if yes then do the validation.

Or you can first to fill the column data, then to do the validation when add the whold Matrix data and to do the validation on any columns before the form add.

Best Regards

Jane Jing

SAP Business One Forums team