Filling prompts via scripts

sdk development
1

I have a report with a prompt to fill an “in list” query. When I execute the report from within BOI and answer the prompt with a list of values (e.g. warehouse? 210,220), it works fine.

When I answer the prompt via a script (e.g. Application.Variables.Item(“warehouses?”).Value = “210,220”), it will only work if I supply just one value (e.g. “210”); when I supply a list of values (e.g. “210,220”) it fails with “Error during SQL execution; ORA-01722: invalid number :-1722”.

I understand what the error is telling me, but I question why it works through BOI proper, but not in the script. Is there a way to get it to work in the script?

Thanks!

Dick McConnell
Polymerland IMO
ph: 8354-4788 or (704) 948-4788
fax: 8354-4915 or (704) 948-4915
e-mail: richard.mcconnell@polymerland.com profs: P024284

Listserv Archives (BOB member since 2002-06-25)

2

Richard,
Use a semicolon instead of a comma as the value separator.

Application.Variables.Item(“warehouses?”).Value = “210;220”

Best regards,

Andrew J. Erthal
Orion Project Manager
Business Objects University

Chicago Office (847) 391-9898
St. Louis Office (314) 209-1994
St. Louis Fax (314) 209-7926

Listserv Archives (BOB member since 2002-06-25)