Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
lukaspuschner
Partner - Creator
Partner - Creator

Case sensitive problem in Set-Analysis

Hello everyone,
i have a question to the logic that is used in Set-Analysis. Set-Analysis is in some cases casesensetive(CS) in some cases caseinsensetive(IS). It looks like a two stage logic, first QV compares with a = and if no data matches he uses the like. But the = is CS and the like is IS. The selection/data-model logic in QV is CS, so it is a problem if i use Set-Analysis to simulate a users selection. Is there a way to use a command like the SQL Collate-Statement, to force the Like-Statement to be CS.
Please see the attatched file,where you can see the Problem.
I would be very thankful some good solutions.
Lukas

4 Replies
tresesco
MVP
MVP

Really strange! And a good notice. I never noticed specially this:

untitled.png

juleshartley
Specialist
Specialist

I'm afraid I haven't got a solution for you - but that's a very interesting analysis! Thanks.

Gysbert_Wassenaar

It's a bug (see here), but I don't know of any workaround.


talk is cheap, supply exceeds demand
juleshartley
Specialist
Specialist

I can only think of something really horrible like switching out lower case letters for an integer... and then using that in the set analysis. ouch!