To retrieve value from a column (Matrix)

[Former Member]

Hello

Does anyone have a sample on how to retrieve values from a column of a row in the matrix.I tried using the following code but it does not work:

sItemCode = oMatrix.Columns.Item(1).Cells.Item(oMatrix.RowCount).Specific

Thanks John

[Former Member · Accepted solution]

Hello,

try this

Dim dsa_EditText As SAPbouiCOM.EditText

dsa_EditText = oMatrix.Columns.Item(ColumnName).Cells.Item(RowNumber).Specific()

Return dsa_EditText.Value

[Former Member · Accepted solution]

The code above is correct but first of all you should now

if the cell is and edittext or a combobox for example. Then you create an object of that kind and assign the specific object of the cell.

[Former Member · Accepted solution]

In that case, you should use the userdatasource (if the column is linked to a userdatasource) or the dbdatasource

userdatasource :

oMatrix.GetLineData(RowNumber)

sItemCode = oForm.DataSources.UserDataSources.Item("Name").ValuEx

DbdataSource

sItemCode = oForm.DataSources.DbDatasource.Item("TableName").GetValue("fieldname", RowNumber)