When attempting to append a single row collection to a multi-row collection, I'm getting an internal error stating that the number of columns is not the same in both collections. The columns are exactly the same in both, so not sure why BP thinks they're different. In fact, one collection was created by copying the other and there were no modifications since. I am unable to get past this issue.
Let me explain what I'm trying to do:
I am looping through rows on a mainframe screen. For each row, I read the data fields I need and store them in a single-row collection. I then append this single-row collection to a "combined" collection that is of the exact same format as the single-row collection and simply accumulates the data read from each row of the mainframe screen. These actions repeat in a loop until all rows on the screen have been processed.
There is no reason that BP should think the collections don't have the same number of fields. Can anyone help with this, or offer a better suggestion as to how to accomplish this task?
Thank you.