BAQ Calculated Field - Using column with special character in name?

Epicor ERP 10
1

I am trying to use a column in calculated field the has a special character in it’s name. I tried enclosing the name in square brackets, but that didn’t work. Any ideas?

image
image.png921×602 27.6 KB

2

External BAQ Editor? I think that’s not valid SQL so it’s splitting the field into two fields.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/154c19c4-95ba-4b6f-b6ca-479288feabfb/characters-that-are-not-allowed-in-table-name-amp-column-name-in-sql-server-?forum=databasedesign

Mark W.

1 Like
3

No, not External BAQ Editor. The query works in SQL Server Mgmt Studio, but not in BAQ Designer. I am doing a PIVOT on the OpCode, two codes have the dash. I can add the pivot fields through display columns and Epicor wraps them in square brackets, but I can’t get it working in Calculated Field Editor.

4

how does the query phrase look on the general tab when you add those fields through the display columns?

5

image