I have a dataTable that is the result of an OleDbQuery with a GetTable call. I create a loop to get each row as a DataRowProxy. I then want to get the values in certain columns by name as the order of the columns can change.
I vividly remember in the past selecting a "GetItem" on a DataRowProxy using a ColumnName. It is GONE! I can only select the GetItem with an Index.
I know a way to get that GetItem by ColumnName but I am told that is an "Engineering Call" that I shouldn't use.
Is there any reason Pega Robotics doesn't expose the GetItem by ColumnName? If not, why not? And if not, then would someone please show me a simple way to loop through the columns in a row by name without a ton of code.