I found a potentially dangerous "bug" in the Update function. When updating a data table using "By Matching Columns", if the final "s" is omitted, this script will update by row. This is an easy mistake to make, and difficult to catch (since no error is thrown). Can this be addressed in the next JMP update? This problem was found on JMP12.
the issue persists even if you use "match column" instead. the truth is any combination of letters that are not "by Matching columns" or "match columns" causes JMP to ignor it and update by row (default unless stated by columns).
dt <<Update( With( dt2 ), Match Column(:UniqueID ==:UniqueID )); // still matching by row
// dt <<Update( With( dt2 ), Match Columns (:UniqueID ==:UniqueID )); // this works fine - by columns
// dt <<Update( With( dt2 ), Msfgsdfsfgatvvch Column (:UniqueID ==:UniqueID )); // no error message either - match by row
what a menace indeed.
the only comfort is that most people including me almost never write the update command but just get it from JMP after doing it manually. Otherwise, by now some nasty consequences would have floated.