Get LineNum from Matrix
i try to get the LineNum from a Matrix.
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?
I suggest to use the SysemDatasource instead of the Matrix
Could you give me an Example, how i can do it?
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.