Error using promptmany to determine optional prompts when multiples

[LisaSullivan]

Hello,
I have 3 optional prompts and I need to be sure that at least one of them has a value entered.  I used Cognos Doc# 1030006.7 and added 3 data items, 1 for each prompt using code like #promptmany('Company', 'string', sq('Empty'))#.
I then have a required prompt to determine if all do not have values entered. 
This works great until I select multiple values on the prompt screen.  I then get an error
Parsing error before or near position: 11 of: "'1-3XBIL';"
I am running on Cognos 8.2 I think MR2.
Help greatly appreciated here, I have looked for some time and cannot find an answer.
Thank you,
Lisa

[raro]

Parsing error before or near position: 11 of: "'1-3XBIL';"

Could imagine that the "-" sign is the problem. Maybe you try to take it out, replace it or escape it?

Have fun!

[LisaSullivan]

Hello,
The - sign is part of the error message not part of my code.

I found a work around for this by having the term None Selected in the Static Choices and Default Selections of the prompt. This way if user just hits finished they get no data and the term None Selected appears in the prompt display. 

Not as elegant as checking if no values were entered in either of the optional prompts but I feel that is probably a Cognos bug.

Thank you,
Lisa