Special Characters in Row-Update Expression

Kinetic ERP
,
1

I’m encountering an issue with single quotes in row-update expressions.

Typical Setup (Using single quotes):

  • Ep Binding: ReportParam.Name
  • Expression: '{MyDataview.UD03_Name_c}'.
  • This expression fails with values like O’Brien

Work around (Using double quotes):

  • Ep Binding: ReportParam.Name
  • Expression: "{MyDataview.UD03_Name_c}"
  • Doesn’t fail but displays O\'Brien instead of O’Brien

image
image402×513 7.59 KB

Does anyone know how to handle special characters like single quotes in Epicor’s row-update expression?

Thanks

2

Copy what you have in expression and put in value or remove the quotes from expression

2 Likes
3

image
image402×285 6.85 KB

Adding double quotes to the expression in the value field resolved the issue.

image
image393×279 3.48 KB

Interestingly, removing the double quotes from the expression caused the event to fail. It appears that string values require double quotes for row-update to function correctly.

3 Likes
4

Because you have a string value that you’re setting. If you were setting a numeric value, you wouldn’t want the double quotes.

1 Like