I'm trying to read data out of a matrix through getlinedata and I keep getting same line.
I have three matrices, all are bound to the same userdatasource (actually a set of 3 overlapping ones in 3 different folders). They are filled through a SboRecordset.doquery, which is channeled through a bound suerdatasource for each column. This works actually quite fast, which was a bit of a surprise for me. btw: I never had to use setlinedata, because this appears to be implicit when you use a matrix.addrow (??) Anyway it is exactly like the example, only three-fold and re-using the userdatasources.
Now I'm trying to read the data back to sync it with the database. Even though I do a getlinedata with a different index each time, I keep getting the last added line back. So I'm trying to read lines from matrix1, but I keep getting the last line from matrix3. No matter what the index, no matter what the indicated matrix.
This is my code:
Set oSboMatrix = .Items(strMatrix).Specific
Set oSboUserDataFieldCode = .DataSources.UserDataSources.Item("FieldCode")
Set oSboUserDataFieldValue = .DataSources.UserDataSources.Item("FieldValue")
For lngTeller = 1 To oSboMatrix.RowCount
strFieldName = oSboUserDataFieldCode.Value
strValue = oSboUserDataFieldValue.Value
Select Case strStatus
Now, can anyone tell me what I'm doing wrong? Is there an example of a working getlinedata somewhere (I can't find it in the examples, sapnotes or this forum). Everyone just tells you to use getlinedata, but there is no example...