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

Sign In or Register to comment.