Welcome to the SRP Forum! Please refer to the SRP Forum FAQ post if you have any questions regarding how the forum works.
RowExists Function
I found something odd with the RowExists function that I thought would be helpful to point out to others that haven't been down this rabbit hole yet. I found debugging some code that a case sensitive record ID was being converted to all caps somewhere before saving the record. I was surprised to see that the RowExists function was taking the passed variable for the ID and actually altering it to all caps. I had to put in the third parameter "KeepCaseFlag" set to True$ for it to not alter the passed variable. I provided test code as an example.
Test RowExistsTest
String = "abcDEF"
Response = RowExists("LISTS", String)
// No such record exists in LISTS table, so response is 0
// String should be "abcDEF", but RowExists actually alters the variable to "ABCDEF"
Assert String equals "abcDEF"
// This assertion fails
end test
Comments