Skip to Content
0
Former Member
Apr 04, 2008 at 09:48 AM

How to updated matrix into related table?

26 Views

hi, can anyone help me below coding how to updated matrix into related table?

Thank you.

For rowNum = 0 To oMatrix.RowCount

oRecordset.Fields.Item("Code").Value = oMatrix.Columns.Item("DSCode").Cells.Item(rowNum).Specific.Value

oRecordset.Fields.Item("Name").Value = oMatrix.Columns.Item("DSName").Cells.Item(rowNum).Specific.Value

oRecordset.Fields.Item("U_RPTC").Value = oMatrix.Columns.Item("DSReport").Cells.Item(rowNum).Specific.Value

oRecordset.Fields.Item("U_USRC").Value = oMatrix.Columns.Item("DSUser").Cells.Item(rowNum).Specific.Value

oRecordset.MoveNext()

Next