I need to update a selected column within all rows in a dataview and then display the change. I added a test button to my grid and when pressed it calls a dataview-condition that iterates over each row. The row event then calls a BAQ to retrieve the additional data that I need to insert into the row. Next, I perform a row update and place the data into TransView, but before it can move on to the next row I get an error. Here’s a screenshot.
I also added another button the directly calls the row event that updates TransView and it works perfectly. I’m guessing that I failed to set up the dataview-condition correctly or something else. Here’s my dataview properties
After what you were telling me I finally realized what you meant. I added a matches dataview to the dataview-condition and it traverses through all of the matched rows now.
In my row processing code, I update two columns:CSM_UnbilledSODtl.Calculated_OrigUnitPrice = “{TransView.Calculated_CSMPrice}” and CSM_UnbilledSODtl.Calculated_CurrentUnitPrice = “{TransView.Calculated_Price}”
But when the event ends the two columns on the display didn’t update. What am I missing?
BTW, I did change my row update to use the matches dataview values, but it’s still not updating the displayed row in the grid. I think I need to go watch the training video again.