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.

0

Comments

0 comments

Please sign in to leave a comment.

Didn't find what you were looking for?

New post