I've run into an issue with case sensitivity on column names with row.get(). Many of the tables in the database I'm accessing share common column names in capitalised snake case (e.g. CHANGED_BY). These shared columns are often part of a data structure, such as a location with a LAT and LONG field.
One of the tables, unfortunately, has left the last word of a couple of column headings in lower case (e.g. CHANGED_by). Rather than rewrite my logic for this single table, or alter the databse itself (over 3 million records) it would be nice if there was a case insensitive version of row.get() to bypass situations like this where the databse structure is not as clean as would be hoped.
I've run into an issue with case sensitivity on column names with
row.get(). Many of the tables in the database I'm accessing share common column names in capitalised snake case (e.g.CHANGED_BY). These shared columns are often part of a data structure, such as a location with aLATandLONGfield.One of the tables, unfortunately, has left the last word of a couple of column headings in lower case (e.g.
CHANGED_by). Rather than rewrite my logic for this single table, or alter the databse itself (over 3 million records) it would be nice if there was a case insensitive version ofrow.get()to bypass situations like this where the databse structure is not as clean as would be hoped.