Query Calculated Columns

PointsWell

Creating a calculated column based on a text contcatenation:

BO.Text1+' '+BO.Text2

Results in the space being stripped in the final output.This happens even if ' ' used

joben

PointsWell wrote

BO.Text1+' '+BO.Text2

We use this sort of concatenation frequently. Should work.

What version are you on mate?

PointsWell

joben wrote

PointsWell wrote

BO.Text1+' '+BO.Text2

We use this sort of concatenation frequently. Should work.

What version are you on mate?

Latest build.

joben

I am also on latest build (2938-) and works for me.

Skärmbild 2021-09-20 091750.png

Skärmbild 2021-09-20 091802.png

Are you having the problem only inside queries, or do you have them in form grids as well?
Are there custom javascripts running in the background messing it up for you?
Database table encoding issues?
You did use "Plain text" as calculation result like the image above? (make sure this option is not hidden due to window height)
You are sure you only included plain text fields when concatenating? If number, it might treat it as addition.

Just brainstorming here.

PointsWell

The issue is that AIM is not dealing with Numbers in a consistent manner:

Concatenations of Numbers with Strings should treat the result as a String.

It does not in Query Calculations. It is stripping the extra space.

joben

PointsWell wrote
The issue is that AIM is not dealing with Numbers in a consistent manner:

Concatenations of Numbers with Strings should treat the result as a String.

It does not in Query Calculations. It is stripping the extra space.

We use AS_STRING when numbers (maybe dates too?) are involved in concatenation.
But I do agree that mixing numbers and strings should render a string. Would also make the calculated column formula more readable.