Strange QV behavior

[giakoum]

Hi all.

I just wanted to concat a fields values into a variable and came accross this strange QV behavior (v11):

If I use this expression, QV hangs!! during reload (desktop edition):

Concat('OR ([Measure Name]= ' & Chr(39) & F1 & Chr(39) & ') ') as fieldListOR

If I use this one, the stupid one, it works just fine :

Replace(Concat('OR ([Measure Name]= A' & F1 & Chr(39) & ') '), 'A', Chr(39)) as fieldListOR

See attached.

The purpose is to put single quotes into the string.

Any ideas why?

[vincent_ardiet]

Hi,

It's amazing, my QV hangs too. And even replacing chr() with other functions like ord() or mid() produces the same phenomena. Nice bug.

But, if you first create your string and then concatenate it works, like this :

[PlanningMeasuresList]:

LOAD

Concat(DISTINCT fieldListOR) as fieldListOR ;

LOAD

' OR ([Measure Name]=' & Chr(39) & F1 & Chr(39) & ')' AS fieldListOR

Resident [MeasuresListLoadTable] ;

Regards,

Vincent

[giakoum]

Nice workaround Vincent!

However it is strange, isn't it? Maybe a bug or is there something we do not know?