Get LineNum from Matrix

M.Zurbrüggen

Hello,

i try to get the LineNum from a Matrix.

My Problem:

If i read pVal.Row -1 i got the Row of the MATRIX, but i want to get the LineNum of the db Table!

I have an order with 5 Lines

Pos.     ItemCode        Row        LineNum

1.         0001               0             0

2.         Textline           1              -

3.         0002               2             1

4.         Textline           3              -

5.          0003              4              2

So, how i can get the LineNum instead of the Rownumber?

ChristianB

Hi,

I suggest to use the SysemDatasource instead of the Matrix

Best Regards

Christian

M.Zurbrüggen

Could you give me an Example, how i can do it?

ChristianB

Assuming your Trigger is somthing in the Matrix row, your SystemDatasource got already loaded.

1. You have to connect to the datasource like: Dim dsDocLines As SystemDatasource = SystemDatasource.GetFromUID(pVal.Form, "RDR1")

2. Now you can read from the datasource like: Dim sLineNum As String = dsDocLines.GetValue("LineNum", iPointer)  'Where iPointer is your Matrix Loop Pointer

hope I could help you with that hint.