Adding conditions in scripts

I need a bit of scripting help from any gurus out there please.

I’ve written a script that creates a report and allows the users to add some conditions to the report. To do this I give them a dialog box and depending on which optionbutton they select I add the various conditions. My conditions use a predfined query in the universe which contain an @select command. This allows the users to get a list of values and select what they want for the report. It works pretty well except for one problem…

When I add the condition to the query it pops up the box for the values to be entered.
When I build and refresh the report it pops the box up again.

Is there a way I can get the window to pop up only once? I have tried setting the myApp.Interactive = FALSE but it didn’t have any effect.

I hope I’ve explained this clearly enough.

Thanks in advance,

Chris Timm
BP Gas Marketing
London, UK.


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