in() function in Impromptu

[yoanka]

Hi,

Have you noticed that in() function doesn't work with commas beetwen values? In docs in found only
in('val','val')
notation, whenenver it gives an error. It works howerver this way:
in('val';'val')

Is it a reported bug?

JH

Ps. I use Impromptu 7.0. Is there any change in newer version?

 

[griffindm]

JH,

Are you referring to the us of the IN clause within the expression editor, or in direct entry SQL? In either case, the IN clause looks for a comma separator between values, which may be either strings or numbers. It has always worked that way. Not sure why you are getting this behavior. Can you give us more info?

Regards,

Dave Griffin




The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[yoanka]

Dave,

Yes, I refer to IN clause in expression editor. I'm sorry for not clear explanation.

Actually I noticed it first in Architect, where Expresssion Editor allows you to type your expression manually, and at the same time doesn't give you only the possible parts of syntax in "Available Components" window. Therefore it was quite difficult to find out what was wrong with my expression.
In Impromptu, however, it works like that: when I use in() clause and type in my first value in Available Components I have these components:
+
,
)
And when I click a comma sign a semicolon appears in the Expression window...

If it is not a bug, how come that it behaves that way?

Greetz,
JH

 

[DoubleD]

There seems to be something wrong with your installation of Impromptu. I have not heard of this bug, and I've used versions 5 - 7.1. The IN clause has always worked with commas separating the values. I've also used the IN clause in Architect 7.0 and it worked fine.

Pain is stress leaving the body.

DoubleD

 

[Recce]

Hi,

This may be a regional settings thing or a setting in the operating system.

 

[yoanka]

Hi,
You are right Recce, it is probably a case of regional settings (I use Polish settings). I will try to live with it

Joanna