I’m building a Text List in Pan X to take the place of a View-as-List form I made in Pan 6. It is working well, but I’ve encountered a place where the view-as-list form has access to data that is not obvious how to access in the Text List.
This form usually has no more than about 40 lines in it due to the type of data it is retrieving. In Pan 6 I did a Select to get the records I wanted, then a couple of Total commands to total 2 numeric fields, which are then displayed on the form using a Summary tile. If there is a way within a Text List to derive the same information, that will take care of my problem. Waiting …
In the meantime, I am considering another solution, which is also problematic. I could process my Text List results a line at a time, and perform the summations of these fields in code. If I click any of the lines, info(“matrixrow”) tells me which line I am on, and tabarray( will give me access to the data in certain columns of that line. That’s all I need, but I am not clicking anything, I want to evaluate the entire matrix of the Text List one row at a a time in a procedure. I am not at all clear on how I can retrieve one row’s tabarray at a time, and process data according to particular elements in that array, without having to do any clicking. I have been all over the Help entries for Text List and Matrix programming, but they all seem to be oriented toward interacting with the matrix rather than processing the contents. Ideas?