@prompt object issue

[Former Member]

Hi

I have built an @prompt object in my universe. (BOXI R2)

Foll is the object:

@Prompt('Enter name ','A',[{'b','a'}],mono,free)

This object works absolutely fine.

1) But when I replace mono with multi, It gives an error 'ORA-00907: missing right paranthesis'

@Prompt('Enter name','A',[{'b','a'}],multi,free)

2) No If I give the foll syntax for multi, then it parses the object fine.

But when I run the report and select multiple values from the LOV, it gives me the save error when the report runs.

'ORA-00907: missing right paranthesis'

@Prompt('Enter name','A',[{'b','a'}],[multi],free)

Can someone help me if the syntax is incorrect or there is any other restriction with 'MULTI'

Thanks in advance.

[Former Member]

Hi,

When you run a prompt which is having multi option then each value should be separated by using ';'

Cheers,

Suresh Babu Aluri.

Edited by: Suresh Babu Aluri on Aug 11, 2009 11:10 PM

[Former Member]

Hi,

You cannot build an object based on an @Prompt with multi selection because the resulr would be something like that:

@Prompt('My values','A',{'a','b'},multi,free)

-->

Select ('a','b') from Table

However you can use an @Prompt with multi selection in a Where clause or a pre-defined filter:

table.column in @Prompt('My values','A',{'a','b'},multi,free)

-->

Select table.column from Table where table.column in ('a', 'b')

Didier