2 Replies Latest reply: Jul 10, 2012 3:29 AM by ioannis giakoumakis RSS

    Strange QV behavior

    ioannis giakoumakis

      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?