Re: passing a parameter to multiple queries?

Hi Brian,

> I'd like to be able to specify the date range once and have the start
> and end dates propagate to all queries without having to cycle through
> each sheet, do a refresh, and re-enter the dates.  Doesn't matter to me
> if the parameter is obtained via a single dialog or reading off of a
> calc cell.  It would be nice if I could specify a default date based on
> the current date.

Hmm, I don't think there's a way to do this without a little programming.

In general, you would need to programmatically refresh the ranges. Two
issues here
- This is Calc API, I don't know how to do this.
- I don't know whether this API supports passing parameters. That is,
  the API could be "refreshRange" (or so), and internally decide that
  it needs to ask for parameters; or it could be "refreshRange( ... )"
  where you can pass in some information.

Even in the latter case ... I think there could be more hurdles, as you
would need to implement an own class supporting a certain interface,
which is not possible in Basic.

Hmm.

Try another way (still some programming, sorry): Instead of using
parameters, let your queries base on fields in a certain table (which is
for this purpose only). Now when it comes you want to refresh all
ranges, run a Basic script which
- asks for the date values
- writes those values into the proper table fields
- refreshes all ranges

If this is where you think you can/want to go, the third still requires
you ask some Calc-API-knowledgable people (I suggest
[email protected]). For the first two, this list here could
certainly help.

Ciao
Frank


-- 
- Frank Schönheit, Software Engineer         [email protected] -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Database                   http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -