Concatenate Error with Firebird
22 February, 2011
Hi, Appears the error below with Firebird when used the Formula Builder Dimension in the View to Concatenate two text fields and after this field was used in the Hierarchy. Do you have some hint?
Hi Arthur,
It looks like Firebird doesn't support concatenating strings with the + symbol, you need to use || instead. However, the Forumula Builder doesn't support using that symbol, your options are to either make a Freehand SQL Calculated Field, or use an advanced function to concatenate the two strings.
It looks like Firebird doesn't support concatenating strings with the + symbol, you need to use || instead. However, the Forumula Builder doesn't support using that symbol, your options are to either make a Freehand SQL Calculated Field, or use an advanced function to concatenate the two strings.